One of the users in the database has plustrace enabled and the other user is not. The dba granted plustrace to public. It works with user A but not with B. After noticing the problem, the steps were done again. It is still not working.
It gives this message:
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
However, plan_table exists.
Click Here to Expand Forum to Full Width