Packages

PROCEDURE DBMS_SUPPORT.START_TRACE

This procedure enables event 10046 trace in the current session

There are two optional Boolean parameters, waits and binds, both of which default to FALSE.

For example to enable event 10046, level 1 trace in the current session use

    EXECUTE dbms_support.start_trace

This is equivalent to

    ALTER SESSION SET EVENTS
    '10046 trace name context forever, level 1';

To enable event 10046, level 4 trace (bind variables) in the current session

    EXECUTE dbms_support.start_trace (binds=>true);

    ALTER SESSION SET EVENTS
    '10046 trace name context forever, level 4';

To enable event 10046, level 8 trace (waits) in the current session

    EXECUTE dbms_support.start_trace (waits=>true);

    ALTER SESSION SET EVENTS
    '10046 trace name context forever, level 8';