-
how to trace other session
I want to trace user session when she running reports to trace all the sql statements how to do it?
Thanks in advance
-
-
Could Try this
exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);
-
Don't forget to switch the tracing off when you've finished
-
Originally Posted by craigdba
exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);
How would you set the trace number and level in the above query???
you can set them in
Exec dbms_system.set_ev(sid,serial#,trace number,trace level);
"What is past is PROLOGUE"
-
you dont, it does a basic sql_trace
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|