OraFAQ Forum: Performance Tuning » how to use dbms_system.set_sql_trace_in

Home » RDBMS Server » Performance Tuning » how to use dbms_system.set_sql_trace_in_session with 10046 level 12

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use dbms_system.set_sql_trace_in_session with 10046 level 12 [message #211297]

Wed, 27 December 2006 19:47

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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 -

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	TPC testing
Next Topic:	too many views

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 11:06:27 CST 2024