SQL> set autot on
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;

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;

ITPub博客

SP2-0611: Error enabling STATISTICS report