This procedure disables event 10046 trace in another session.
The SID, serial# of the target session can be obtained from V$SESSION.
Argument Name | Type | In/Out | Default? |
SID | NUMBER | IN | |
SERIAL | NUMBER | IN |
The serial number can also be specified as 0
For example to disable event 10046 trace in a session with SID 9, serial number 29 use:
EXECUTE dbms_support.stop_trace_in_session (9, 29);
This is equivalent to:
EXECUTE dbms_system.set_ev (9, 29, 10046, 0, '');