James's Blog

Oracle: DBMS_SYSTEM Package

1) ksdwrt
exec dbms_system.ksdwrt(n, message);
"n" indicates the destination
1 - write to trace file
2 - write to alert log
3 - write to both

2) set_sql_trace_in_session
exec dbms_system.set_sql_trace_in_session(sid, serial#, true);

3) set_ev
exec dbms_system.set_ev(sid,serial#, event, level, name);
exec dbms_system.set_ev(31, 97, 10046, 4, '');
level indicates:
1 - standard sql_trace functionality.
4 - as level 1 plus tracing of bind variables
8 - as level 1 plus wait events
12 - as level1 plus bind variables and wait events.

4) read_ev
exec dbms_system.read_ev(event,output);
if output = 1 the event is being traced.

posted by James Pei @ 4:06 PM