Skip to main content

Posts

Showing posts from November, 2014

SP2-0618: Cannot find the Session Identifier.

Today I could not enabled autorace and reason was SP2-0618. After looking for in google I found solution and now want to share it. SQL> set autotrace traceonly; SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report To enable autotrace PLUSTRACE role should be exists! If not exists create it. Under $ORACLE_HOME\sqlplus\admin\ you may execute by SYS user  SQL> @$ORACLE_HOME\sqlplus\admin\plustrce.sql;  Another way you may just manually create plustrace role and assign select on necessary views; 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. At the end grant plustrace role to needed user; SQL> ...