explain plan - choose plan_table

[Ivan Bukovcan]

Hi,

I need to tune selects. I'd like to use explain plan feature in scheme in which I don't have CREATE privileges (security issue).
PL/SQL developer then asks "Plan table does not exist, create it?" but when I choose OK, it will fail with exception "insufficient privileges" - which is logical.
But my question is: Is there any possibility to redirect explain plan table to different schema in which PLAN_TABLE exists and I have insert privileges?
If yes, it would be nice to include this as option in Preferences.

 

[gulhaugen]

This is described somewhere in more detail, but what you have to do is create a plan_table in a different schema, and grant it to public. That table is then used.

 

[Marco Kalter]

You also have to create a plan_table synonym, either private or public.