Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PROCEDURE DBMS_SUPPORT.STOP_TRACE

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