DBMS_SUPPORT.START_TRACE Procedure

This procedure enables event 10046 trace in the current session

Argument Name Type In/Out Default?
WAITS BOOLEAN IN DEFAULT
BINDS BOOLEAN IN DEFAULT

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);

This is equivalent to:

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);

This is equivalent to:

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