RE: Unable to do a 10046 trace on another users session

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: