为什么我不能设置查看执行计划
SQL> conn system/oracle
Connected.
SQL> drop table plan_table;
Table dropped.
SQL> start ?\rdbms\admin\utlxplan
Table created.
SQL> grant all on plan_table to public;
Grant succeeded.
SQL> start ?\sqlplus\admin\plustrce
SQL>
SQL> drop role plustrace;
Role dropped.
SQL> create role plustrace;
Role created.
SQL>
SQL> grant select on v_$sesstat to plustrace;
grant select on v_$sesstat to plustrace
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> grant select on v_$statname to plustrace;
grant select on v_$statname to plustrace
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> grant select on v_$mystat to plustrace;
grant select on v_$mystat to plustrace
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL>
SQL> set echo off
SQL> grant plustrace to public;
Grant succeeded.
SQL> conn scott/tiger
Connected.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier.Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL>
