Monday 30 January 2012

enable sql trace based on client process number

begin for i in ( select sid,serial# from v$session where process in ( 22688,22700,22712,22723,22734,22745,22756)) loop --dbms_monitor.session_trace_disable(i.sid,i.serial#);
dbms_monitor.session_trace_enabled(i.sid,i.serial#); end loop; end; /

No comments: