Home > Oracle DBA > SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled

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

September 18, 2014

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

# Problem while turning on autotrace with statistics
Error:-
SQL>set autotrace on statistics
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS reportCause:-
autotrace privs not exists.
Solution:-
cd $ORACLE_HOME/rdbms/admin
sqlplus system
@utlxplan
create public synonym plan_table for plan_table;
grant all on plan_table to public;
exit
cd $ORACLE_HOME/sqlplus/admin
sqlplus / as sysdba
@plustrce
grant plustrace to public
Advertisements
Categories: Oracle DBA
%d bloggers like this: