Indexes‎ > ‎

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;


Comments