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;