Hi,

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.

Any ideas?

Thanks