Packages

PROCEDURE DBMS_SUPPORT.START_TRACE_IN_SESSION

This procedure enables event 10046 trace in another session

The SID, serial# of the target session can be obtained from V$SESSION.

The serial number can also be specified as 0

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 a session with SID 9, serial number 29 use

    EXECUTE dbms_support.start_trace_in_session (9, 29);

This is equivalent to

    EXECUTE dbms_system.set_ev (9, 29, 10046, 1, '');

To enable event 10046, level 4 trace (bind variables) in a session with SID 9, serial number 29 use

    EXECUTE dbms_support.start_trace_in_session (9, 29, binds->true);

    EXECUTE dbms_system.set_ev (9, 29, 10046, 4, '');

To enable event 10046, level 8 trace (waits) in a session with SID 9, serial number 29 use

    EXECUTE dbms_support.start_trace_in_session (9, 29, waits->true);

    EXECUTE dbms_system.set_ev (9, 29, 10046, 8, '');