-
for some reason, only on production, if I set autotrace on...
I do not get the info at the end of an explain plan...
this is all I get:
Statistics
----------------------------------------------------------
0 recursive calls
1160 rows processed
I run tkprof and see this after the plan info:
error during parse of EXPLAIN PLAN statement
ORA-00942: table or view does not exist
Now I made a plan_table as sys, made a public synonym, and grant all SUID to it... I never saw this before. Id rather not have to go to tkprof
thanks.
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
|