Tracing Session / System

Session

To enable

select 'exec dbms_system.set_ev(' ||sid||','||serial#||',10046,0,'''');' from v$session where username='<username>';

To Disable

select 'exec dbms_system.set_ev(' ||sid||','||serial#||',10046,12,'''');' from v$session where username='<username>'

System To enable system wide tracing

ALTER SYSTEM SET sql_trace = true SCOPE=MEMORY;

To stop the trace

ALTER SYSTEM SET sql_trace = false SCOPE=MEMORY;