Table of Contents

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

Example

set autotrace TRACEONLY;