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

Thread: AUTOTRACE not working properly

Hybrid View

  1. #1
    Join Date
    Mar 2000
    Posts
    39

    AUTOTRACE not working properly

    Hi everyone, I ran plustrce.sql as SYS. Then granted the role PLUSTRACE to a user. I then logged in as that user and ran SET AUTOTRACE ON and ran a query. The statistics part works, but the execution plan returns the following error:

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


    SP2-0612: Error generating AUTOTRACE EXPLAIN report

    What is wrong? Thanks in advance for your help.
    Thanks,
    Afshin.

  2. #2
    Join Date
    Mar 2000
    Posts
    39
    Forgot, after I logged in as that user, ran I ran the utlxplan.sql statement.
    Thanks,
    Afshin.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Are you trying to explain a view or a function call? Basically, you are trying to explain something for which you do not have permission on all it's dependant's objects.
    Jeff Hunter

  4. #4
    Join Date
    Mar 2000
    Posts
    39
    You are right, I was doing a count of v$parameter as a test to see the execution plan and statistics. When I queried a user table the execution plan showed. Thanks for your help.
    Thanks,
    Afshin.

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