how to trace other session

[vision]

I want to trace user session when she running reports to trace all the sql statements how to do it?

Thanks in advance

[davey23uk]

dbms_system.set_ev

[craigdba]

exec dbms_system.set_sql_trace_in_session('sid','serial#',TRUE);

[cis_groupie]

Don't forget to switch the tracing off when you've finished

[dbasan]

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);

[davey23uk]

you dont, it does a basic sql_trace