DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: plustrace

  1. #1
    Join Date
    Mar 2004
    Posts
    53

    plustrace

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select * from session_roles and paste the output

  3. #3
    Join Date
    Mar 2004
    Posts
    53
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width