Table 2

Program Description Notes
CLIENT_ID_TRACE_ENABLE Enable / Disable
Tracing for
A given Client Identifier
  • Trace data may be written to many trace files as the trace may effect multiple connected sessions with the same client identifier.
CLIENT_ID_TRACE_DISABLE
  Enable tracing for CLIENT_IDENTIFIER johnny:127.0.0.2
with wait information but no bind information 
EXECUTE DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE('johnny:127:0.0.2',TRUE,FALSE);
SERV_MOD_ACT_TRACE_ENABLE Enable / Disable
Tracing for
(Service Name/MODULE/ACTION) combination.
  • Trace data may be written to many trace files as the trace may effect multiple connected sessions.
SERV_MOD_ACT_TRACE_DISABLE
  Enable tracing for servide_name HR
but only for the ADDEMPLOYEE module and include wait and bind information. 
EXECUTE DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('HR','ADDEMPLOYEE', DBMS_MONITOR.ALL_ACTIONS,TRUE,TRUE,NULL);
SESSION_TRACE_ENABLE Enable / Disable
Tracing for
a session identifier (SID)
  • Session must exist
  • Traces only a given session
  • Enables / Disables a trace for the instance submitter is connected to.
SESSION_TRACE_EISABLE
  Enable tracing for session id 142 and include wait and bind information 
EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(145,34, TRUE, TRUE);