启用SQL执行计划，遇到没有启用 PLUSTRACE 角色

点击(此处)折叠或打开

1. SQL> show user
   
2. USER is "SCOTT"
   
3. SQL> set autot on
   
4. SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
   
5. SP2-0611: Error enabling STATISTICS report
   
6. SQL> conn / as sysdba
   
7. Connected.
   
8. SQL> grant plustrace to scott;
   
9. grant plustrace to scott
   
10.       *
    
11. ERROR at line 1:
    
12. ORA-01919: role 'PLUSTRACE' does not exist
    
13. 
    
14. 
    
15. SQL> !ls $ORACLE_HOME/sqlplus/admin
    
16. 
    
17. SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql
    
18. SQL>
    
19. SQL> drop role plustrace;
    
20. drop role plustrace
    
21.           *
    
22. ERROR at line 1:
    
23. ORA-01919: role 'PLUSTRACE' does not exist
    
24. 
    
25. 
    
26. SQL> create role plustrace;
    
27. 
    
28. Role created.
    
29. 
    
30. SQL>
    
31. SQL> grant select on v_$sesstat to plustrace;
    
32. 
    
33. Grant succeeded.
    
34. 
    
35. SQL> grant select on v_$statname to plustrace;
    
36. 
    
37. Grant succeeded.
    
38. 
    
39. SQL> grant select on v_$mystat to plustrace;
    
40. 
    
41. Grant succeeded.
    
42. 
    
43. SQL> grant plustrace to dba with admin option;
    
44. 
    
45. Grant succeeded.
    
46. 
    
47. SQL>
    
48. SQL> set echo off
    
49. SQL> grant plustrace to scott;
    
50. 
    
51. Grant succeeded.
    
52. 
    
53. SQL> set autot on
    
54. SQL> spool off

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26066458/viewspace-2123342/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26066458/viewspace-2123342/