SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
解决方法:
SQL> conn / as sysdba
Connected.
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql;
Connected.
SQL> @$ORACLE_HOME/rdbms/admin/utlxplan.sql;
Table created.
SQL> @$ORACLE_HOME/sqlplus/admin/plustrce.sql
sql>conn lerry/lerry
sql>set autot on
SQL> set autot on
SP2-0613: Unable to verify PLAN_TABLE format or existence
SP2-0611: Error enabling EXPLAIN report
是因为lerry用户下没有plan_table
1. 可以在lerry用户下执行@$ORACLE_HOME/rdbms/admin/utlxplan.sql;
2. 也可以在sys用户下
SQL>create public synonym plan_table for plan_table;
SQL>grant all on plan_table to public;
SQL>grant all on plan_table to public;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-746210/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24849178/viewspace-746210/