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