SQL Plus - Autotrace system variable

Card Puncher Data Processing

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;





Discover More
Sql Developer Autotrace
Oracle Database - Autotrace

Autotrace is: a system variable of sql plus can also be found in SQL Developer AUTOTRACE provides you: an execution plan (such as explain plan) and some important regarding its actual execution....
Card Puncher Data Processing
SQL PLUS - Array size

The array size is a configuration variable which set the fetch size. Valid values are 1 to 5000. A large value increases the efficiency of queries and subqueries that fetch many rows, but requires more...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...



Share this page:
Follow us:
Task Runner