一次oracle autorace排错

最新推荐文章于 2025-08-13 17:52:41 发布

转载最新推荐文章于 2025-08-13 17:52:41 发布 · 128 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/520550

文章标签：

#数据库

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

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

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.

本文转自 jxwpx 51CTO博客，原文链接：http://blog.51cto.com/jxwpx/222900，如需转载请自行联系原作者