授权scott用户可以开启执行计划，脚本如下：
[oracle@rac1 admin]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on Sat Oct 12 02:02:28 2013 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql Table created. SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql SQL> SQL> drop role plustrace; Role dropped. SQL> create role plustrace; Role created. SQL> SQL> grant select on v_$sesstat to plustrace; Grant succeeded. SQL> grant select on v_$statname to plustrace; Grant succeeded. SQL> grant select on v_$mystat to plustrace; Grant succeeded. SQL> grant plustrace to dba with admin option; Grant succeeded. SQL> SQL> set echo off SQL> grant plustrace to scott; Grant succeeded.
利用scott开启执行计划
SQL> conn scott Enter password: Connected. SQL> set autotrace on; SQL> select * from tab; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- DEPT TABLE EMP TABLE BONUS TABLE SALGRADE TABLE T TABLE E1 TABLE 6 rows selected. Execution Plan ---------------------------------------------------------- ERROR: ORA-01039: insufficient privileges on underlying objects of the view SP2-0612: Error generating AUTOTRACE EXPLAIN report Statistics ---------------------------------------------------------- 287 recursive calls 0 db block gets 709 consistent gets 1 physical reads 0 redo size 755 bytes sent via SQL*Net to client 492 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 12 sorts (memory) 0 sorts (disk) 6 rows processed
