-
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.
-
Forgot, after I logged in as that user, ran I ran the utlxplan.sql statement.
Thanks,
Afshin.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|