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