SQL Plus - Autotrace system variable

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

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

Advertising

3 - 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.

4 - Example

set autotrace TRACEONLY;
lang/sqlplus/autotrace.txt · Last modified: 2017/09/06 19:30 by gerardnico