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

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


SP2-0611: Error enabling STATISTICS report

–Got below problem:

SQL> conn SIT/SIT
Connected.

SQL>  set timing on
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier.  Check PLUSTRACE role is enabled

SP2-0611: Error enabling STATISTICS report

SOL:

SQL> conn / as sysdba
Connected.
SQL> drop role plustrace;

 SQL> drop role plustrace;

Role dropped.

 SQL>  create role plustrace;

Role created.

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> grant plustrace to SIT;

Grant succeeded.

SQL>  conn SIT/SIT
Connected.
SQL> set timing on
SQL> set autotrace on

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply