SQL Plus - Autotrace system variable

About

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

Articles Related

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.

Example

set autotrace TRACEONLY;