一次oracle autorace排错

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职场排错数据库