set autotrace off | The default: nothing is reported |
set autotrace on explain | Only display the optimizer execution path. |
set autotrace on statistics | Only SQL statement execution statistics. |
set autotrace on | Display both the optimizer execution path and the SQL statement execution statistics. |
set autotrace traceonly | Like set autotrace on but do not print SQL statement results. |
AUTOTRACE
system variable. v$statname
). PLAN_TABLE
in his schema and
PLUSTRACE
roles enabled. $ORACLE_HOME/rdbms/admin/catplan.sql
script. PLUSTRACE
role is created with the $ORACLE_HOME/sqlplus/admin/plustrce.sql
script. This role grants the necessary privileges to access the dynamic performance views $ sqlplus / as sysdba SQL> @?/sqlplus/admin/plustrce.sql SQL> grant plustrace to rene;
flagger
to a value different from off
), autotrace is not available and causes