I want to trace user session when she running reports to trace all the sql statements how to do it?
Thanks in advance
Printable View
I want to trace user session when she running reports to trace all the sql statements how to do it?
Thanks in advance
dbms_system.set_ev
exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);
Don't forget to switch the tracing off when you've finished :)
Quote:
Originally Posted by craigdba
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);
you dont, it does a basic sql_trace