RE: question about dbms_syste.set_sql_trace_in_session
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 08:59:55 -0600
You shouldn't have to turn tracing off to see a trace file. However, you
do have to make sure that session (sid.serial#) emits at least one line
of trace data; otherwise, the Oracle kernel won't have opened the trace
file yet for writing.
Note that with DBMS_SYSTEM.START_SQL_TRACE_IN_SESSION, you will not be
able to activate *extended* SQL tracing (levels higher than 1). To get
that, you'll have to use DBMS_SYSTEM.SET_EV(sid, serial#, 10046, level,
''), or--better yet--DBMS_SUPPORT.START_TRACE_IN_SESSION. It's
confusing, I know. If you want to see either "bind" or "wait" data, then
stay away from the package that has the word "SQL_TRACE" in the name.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 3/23 Park City, 4/6 Seattle
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Senthil Kumar
Sent: Wednesday, March 03, 2004 7:44 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: question about dbms_syste.set_sql_trace_in_session
Hi,
run exec dbms_system.set_sql_trace_in_session(sid,serial#,false);
then check the trace dir.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of ryan.gaffuri@xxxxxxx
Sent: Wednesday, March 03, 2004 6:35 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: question about dbms_syste.set_sql_trace_in_session
i ran the following
exec dbms_system.set_sql_trace_in_session(sid,serial#,true);
Procedure Completed Successfully
I then went to my udump directory to check for a trace file and could
not
find one?
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
