| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: question about dbms_syste.set_sql_trace_in_session
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Senthil Kumar
Sent: Wednesday, March 03, 2004 7:44 AM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net
Sent: Wednesday, March 03, 2004 6:35 PM
To: oracle-l_at_freelists.org
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?
 |
 |