普通用户使用set autotrace

关于set autotrace

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