[oracle@rman1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 14:31:03 2017

SQL> conn scott/tiger

Connected.

SQL> set autot trace

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

SP2-0611: Error enabling STATISTICS report

SQL> conn / as sysdba

Connected.

SQL> grant plustrace to scott;

grant plustrace to scott

*

ERROR at line 1:

ORA-01919: role 'PLUSTRACE' does not exist

SQL> @$ORACLE_HOME/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>

SQL> grant plustrace to scott;

Grant succeeded.

SQL> conn scott/tiger

Connected.

SQL> set autot trace

ITPub博客

SP2-0618:Cannot find the Session Identifier.SP2-0611