Re: RE: Unable to do a 10046 trace on another users session
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Apr 2004 20:57:55 +0800
hi
I had saw some information from metalink but i can not find=
the URL now.
oracle forms can spawns many session for a single process .=
as you say :
> called session doesn't inherit the caller's 10046 trace level=
attribute
Best regards
yahoo id: feng_chunpei
A new dba from china
---- from the mail-----
>One thing to consider is that some Oracle Forms applications do=
a lot of
>session spawning. If you don't trace all of the Oracle sessions=
that are
>involved in your user action, you're not going to see the work=
done in
>all of those sessions.
>
>Unfortunately, when one Oracle session spawns another, the=
called
>session doesn't inherit the caller's 10046 trace level=
attribute. The
>"trick" is to identify all the Oracle sessions that participate=
in your
>user action.
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>* Nullius in verba *
>
>Upcoming events:
>- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22
>Pittsburgh
>- SQL Optimization 101: 4/19 Denver, 5/3 Boston, 5/24 San Diego
>- Hotsos Symposium 2005: March 6-10 Dallas
>- Visit www.hotsos.com for schedule details...
>
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arghadeep=
Chatterjee
>Sent: Monday, April 26, 2004 5:18 AM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Unable to do a 10046 trace on another users session
>
>Hi All,
>I am trying to trace another users session (10046 trace) by=
using
>DBMS_SYSTEM as mentioned in Cary's book my problem is though=
everything
>runs out fine the resulting trace file only shows the last line=
of my
>current SQL and doesnt report any SQL of the application I am=
trying to
>trace.I am enabling the trace form SQLPLUS while the application=
is
>Oracle Forms 6i.Any ideas the steps I have followed is exact=
replica of
>one shown in hotsos.Thanks
>Regards
>Arghadeep Chatterjee
>DBA "KSPL"
>----------------------------------------------------------------=
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>----------------------------------------------------------------=
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------=
>To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
>----------------------------------------------------------------=
-
>
>.
=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
