AUTOTRACE |
AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
|
Causes SQL*Plus to display a report on the execution of successful SQL DML statements.
Keywords
ON
Causes a trace report to be displayed after each execution of a DML statement.
OFF
No trace report is displayed. This option is the default.
TRACEONLY
Causes a trace report to be displayed, but suppresses the printing of query data.
EXPLAIN
Causes SQL*Plus to show the query execution plan for each SQL DML statement that is executed. The EXPLAIN PLAN statement is used to get the execution plan, and your plan table must have a schema for this option to work.
STATISTICS
Causes SQL*Plus to display execution statistics for each executed statement.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.