plustrace

[pvnad1]

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

[pando]

select * from session_roles and paste the output

[pvnad1]

Hi,

Output is pasted below. I logged in as USER45. plustrace is working in DMO and is found when this command is issued there.



SQL> select * from session_roles
2 /

ROLE
------------------------------
USER45_R
SHARED_R
DMO_R


Execution Plan
----------------------------------------------------------
ERROR:
ORA-01039: insufficient privileges on underlying objects of the view


SP2-0612: Error generating AUTOTRACE EXPLAIN report

[davey23uk]

http://asktom.oracle.com/~tkyte/article1/autotrace.html