SET AUTOTRACE OFF – Turn off AUTOTRACE This is the default.
SET AUTOTRACE ON EXPLAIN – Shows only the optimizer execution path.
SET AUTOTRACE ON STATISTICS – Shows only the SQL statement execution statistics.
SET AUTOTRACE ON – Shows both the optimizer execution path and the SQL statement execution statistics.
SET AUTOTRACE TRACEONLY – Similar to “SET AUTOTRACE ON”, but suppresses the printing of the user’s query output. Great for checking execution times for queries without looking at the query output.
You can use the following snippet of code to setup autotrace in SQL*Plus:
col PLAN_PLUS_EXP for a122 set lines 500 set autot trace exp set time on timing on
Posted by Charles Kim, Oracle ACE