opyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
解决方法如下：
[oracle@clu2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 6 10:05:38 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> @?/sqlplus/admin/plustrce;
SQL>
SQL> drop role plustrace;
drop role plustrace
*
ERROR at line 1:
ORA-01919: role 'PLUSTRACE' does not exist
SQL> create role plustrace;
Role created.
SQL>
SQL> grant select on v_$sesstat to plustrace;
Grant succeeded.
SQL> grant select on v_$statname to plustrace;
Grant succeeded.
SQL> grant select on v_$mystat to plustrace;
Grant succeeded.
SQL> grant plustrace to dba with admin option;
Grant succeeded.
SQL>
SQL> set echo off
SQL> grant plustrace to jkadmin;
Grant succeeded.
[oracle@clu2 ~]$ sqlplus jkadmin/jk123
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 6 10:06:10 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> set autotrace on
以上为最简单的方法，其他的方法：
SQL> grant select on v_$sesstat to jkadmin;
Grant succeeded.
SQL> grant select on v_$statname to jkadmin
2 ;
Grant succeeded.
SQL> grant select on v_$session to jkadmin;
Grant succeeded.
©著作权归作者所有：来自51CTO博客作者jxwpx的原创作品，如需转载，请注明出处，否则将追究法律责任
oracle职场排错数据库