问题:使用scott用户开启trace功能时,报错:
SQL> set autotrace traceonly
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
解决:
[oracle@oel6 ~]$ sqlplus / as sysdba
SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql
SQL> grant plustrace to scott;
重新登录scott用户
[oracle@oel6 ~]$ sqlplus scott/tiger
SQL> set autotrace traceonly
OK!
SQL> set autotrace traceonly
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
解决:
[oracle@oel6 ~]$ sqlplus / as sysdba
SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql
SQL> grant plustrace to scott;
重新登录scott用户
[oracle@oel6 ~]$ sqlplus scott/tiger
SQL> set autotrace traceonly
OK!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30373263/viewspace-2128984/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30373263/viewspace-2128984/