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> grant plustrace to ulfet;   
Grant succeeded.  
 
No comments:
Post a Comment