Controlling the Report : AUTOTRACE « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. AUTOTRACE

You can control the report by setting the AUTOTRACE system variable.

  1. SET AUTOTRACE OFF: No AUTOTRACE report is generated(This is the default).
  2. SET AUTOTRACE ON EXPLAIN: The AUTOTRACE report shows only the optimizer execution path.
  3. SET AUTOTRACE ON STATISTICS: The AUTOTRACE report shows only the SQL statement execution statistics.
  4. SET AUTOTRACE ON: The AUTOTRACE report includes both the optimizer execution path and the SQL statement execution statistics.
  5. SET AUTOTRACE TRACEONLY: Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

Quote from www.Oracle.com









29.22.AUTOTRACE
29.22.1.Controlling the Report
29.22.2.set autotrace traceonly explain
29.22.3.SET AUTOTRACE OFF
29.22.4.Autotrace an self join
29.22.5.autotrace count(*)
29.22.6.autotrace merge command
29.22.7.autotrace table with/without an index