RSA Scripts

DBMS_MONITOR trace

DBMS_MONITOR trace.

  1. Oracle
  2. Trace
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

Syntax :
        DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE(client_id,waits,binds);
        DBMS_MONITOR.SESSION_TRACE_ENABLE(SID,SERIAL#, waits, binds);

Examples :

    Start schema trace : exec DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE('APP_SCHEMA');
    End schema trace        :    exec DBMS_MONITOR.CLIENT_ID_TRACE_DISABLE('APP_SCHEMA');

    Start session trace       :   exec DBMS_MONITOR.SESSION_TRACE_ENABLE(50,100,true,true);
    End session trace  : exec DBMS_MONITOR.SESSION_TRACE_DISABLE(50,100);