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

Thread: AUTOTRACE not working properly

  1. 05-07-2003, 04:37 PM #1
    akhorram
    akhorram is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 05-07-2003, 04:41 PM #2
    akhorram
    akhorram is offline Junior Member
    Join Date
    Mar 2000
    Posts
    39
    Forgot, after I logged in as that user, ran I ran the utlxplan.sql statement.
    Thanks,
    Afshin.
    Reply With Quote Reply With Quote
  3. 05-07-2003, 04:42 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  4. 05-07-2003, 06:21 PM #4
    akhorram
    akhorram is offline Junior Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width