SQL Plus - Autotrace system variable

About

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

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>autot of autotrace are the same then you can use “set autot on” for instance.</note>

set autotrace TRACEONLY;