SET AUTOTRACE OFF ---------------- 不生成AUTOTRACE 报告,这是缺省模式
SET AUTOTRACE ON EXPLAIN ------ AUTOTRACE只显示优化器执行路径报告
SET AUTOTRACE ON STATISTICS -- 只显示执行统计信息
SET AUTOTRACE ON ----------------- 包含执行计划和统计信息
SET AUTOTRACE TRACEONLY ------ 同set autotrace on,但是不显示查询输出
默认情况下,普通用户是没有set auotrace的权限的
SQL> conn test/oracle
Connected.
SQL> set autotrace on;
SQL> select * from user_tables;
Error ORA-942 while gathering statistics
SP2-0612: Error generating AUTOTRACE report
no rows selected
SP2-0612: Error generating AUTOTRACE report
Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view
SP2-0612: Error generating AUTOTRACE EXPLAIN report
SP2-0612: Error generating AUTOTRACE STATISTICS report