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.
Subscribe to:
Post Comments (Atom)
Followers
About Me
- reiki
- Torrance, CA, United States
No comments:
Post a Comment