Errors

How to enable autotrace?

SQL> set autotrace on

Cannot find the Session Identifier. Check PLUSTRACE role is enabled

Error enabling STATISTICS report

Action:
A PLAN_TABLE table must exist in schema and PLUSTRACE role granted beforeAUTOTRACE usage.

1. Login as system

sqlplus system/system

2. Then run following script
@$ORACLE_HOME/sqlplus/admin/plustrce.sql

3. grant plustrace to <>;

4.Then issue following commad

grant select any dictionary to <> ;