SQL Plus - Autotrace system variable

About

Autotrace is a system variable that permits to set the autotrace functionality.

Syntax

SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]

where:

  • OFF: No autotrace
  • ON. All
    • ON EXPLAIN. Only the optimizer execution path is shown.
    • ON STATISTICS. Only the SQL Statement execution statistics is shown.
  • TRACEONLY. Show me the statistics but hold the data. The same that ON but without the printing of the user's query output.

<wrap tip >autot of autotrace are the same then you can use “set autot on” for instance.</note>

Example

set autotrace TRACEONLY;

Powered by ComboStrap