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

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Mon, 26 Apr 2004 05:42:26 -0500
Message-ID: <00bc01c42b7b$2e0c8240$1401a8c0@CVMLAP02>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Arghadeep Chatterjee Sent: Monday, April 26, 2004 5:18 AM
To: oracle-l_at_freelists.org
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_at_freelists.org 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_at_freelists.org
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
-----------------------------------------------------------------

Received on Mon Apr 26 2004 - 05:40:36 CDT