Printable View
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
select * from session_roles and paste the output
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