SP2-0618 Cannot find the Session Identifier. Check PLUSTRACE role is enabled

[oracle@localhost ~]$ sqlplus scott/oracle              --仪scott用户登录，这里用soctt用户查看当前session的执行计划信息

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Apr 16 11:01:05 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
SQL>

 

以上报错的原因是scott用户没有plustrace角色相关的权限，而不是数据库中没有plustrace角色。

 

解决方法：

QL> conn / as sysdba
Connected.
SQL> grant dba to scott;

Grant succeeded.

SQL> conn scott/oracle
Connected.
SQL> set autotrace on
SQL>