DISABLE_OPT_TRACE

2026-02-02 07:28:28  Updated

The DISABLE_OPT_TRACE procedure disables end-to-end tracing for the optimizer of the current session.

Syntax

DBMS_XPLAN.DISABLE_OPT_TRACE;

Examples

Disable end-to-end tracing for the optimizer of the current session.

obclient> CALL DBMS_XPLAN.DISABLE_OPT_TRACE();
Query OK, 0 rows affected

Contact Us