DBMS_SUPPORT.STOP_TRACE Procedure

This procedure disables event 10046 trace in the current session.

Argument Name Type In/Out Default?
None

The serial number can also be specified as 0

For example to disable event 10046 trace in the current session use:

EXECUTE dbms_support.stop_trace

This is equivalent to:

ALTER SESSION SET EVENTS
'10046 trace name context off';