Sunday, March 18, 2012

cannot run set autotrace on statistics;

The sqlplus command set autotrace on statistics; gave SQL> set autotrace on statistics SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled SP2-0611: Error enabling STATISTICS report SQL> connect / as sysdba Connected. SQL> grant plustrace to aarav; grant plustrace to aarav * ERROR at line 1: ORA-01919: role 'PLUSTRACE' does not exist executed $ORACLE_HOME/sqlplus/admin/plustrce.sql as sys user then "grant PLUSTRACE to aarav" then autotrace worked fine.

No comments:

Post a Comment

Followers

About Me

Torrance, CA, United States