Home » RDBMS Server » Performance Tuning » how to use dbms_system.set_sql_trace_in_session with 10046 level 12
how to use dbms_system.set_sql_trace_in_session with 10046 level 12 [message #211297] Wed, 27 December 2006 19:47 Go to next message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member

Hi,
Oracle 9i on Linux (RAC)

i am tracing session for Oracle job where i could found the trace file in bdump.

however, i am using following method which is not giving me wait related information
exec dbms_system.set_sql_trace_in_session(sid,serial#,true/false);



Later in Orafaq only i found the following information

Behind the scenes, it actually just calls DBMS_SYSTEM.SET_EV to set event 10046 at level 1.

DBMS_SYSTEM.SET_EV (
   si  IN  BINARY_INTEGER,
   se  IN  BINARY_INTEGER,
   ev  IN  BINARY_INTEGER,
   le  IN  BINARY_INTEGER,
   nm  IN  BINARY_INTEGER);



My question is can i use DBMS_SYSTEM.SET_EV as a replacement to exec dbms_system.set_sql_trace_in_session so that i can use event 10046 with level 12?
or
DBMS_SYSTEM.SET_EV is to be followed again with dbms_system.set_sql_trace_in_session?

Else can i use dbms_system.set_sql_trace_in_session with 10046 level 12?

Thanks and Regards,
Pratap

Re: how to use dbms_system.set_sql_trace_in_session with 10046 level 12 [message #211299 is a reply to message #211297] Wed, 27 December 2006 19:59 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Are you incapable or unwilling to use GOOGLE?

Results 1 - 10 of about 980 for Oracle enable SQL_TRACE level 12. (0.11 seconds)

AskTom "SQL_TRACE -- how to enable in other sess..."
But why the Oracle Manual indicates "alter system set sql_trace = TRUE" if this ... Follow up on my previous comment, you can set events 10046 at level 12 ...
asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:330817260752 - 137k -
Re: how to use dbms_system.set_sql_trace_in_session with 10046 level 12 [message #211300 is a reply to message #211299] Wed, 27 December 2006 20:18 Go to previous message
kumarsz
Messages: 180
Registered: March 2005
Location: canada
Senior Member

Apologies..

first i tried orafaq where almost every time i get the required information and advice.

i posted the question to clear my doubt since i wasn't clear about using dbms_system.set_ev

Once again sorry for taking your time

i got information at following address
http://julian.dyke.users.btopenworld.com/com/Diagnostics/Trace/EnablingTrace.html

Thanks and Regards,
Pratap


Previous Topic: TPC testing
Next Topic: too many views
Goto Forum:
  


Current Time: Sat Dec 03 12:08:23 CST 2016

Total time taken to generate the page: 0.07137 seconds