Explain Plan

[LaurenM]

I was wondering if you could tell me what permission using the explain plan window uses.
Whenever I try to use it with my username I get a ORA-01031: insufficient privileges error. I would like to be able to tell our DBA what permission flag he needs to change.

 

[Marco Kalter]

You need select/insert/delete privileges on the PLAN_TABLE, as well as select privileges on the tables and views that are used in the SQL statement for which you are trying to get a query plan.

 

[da bull]

Our DBA team does not want to give us access to the PLAN_TABLE, and instead have created an internal one for us to use called DBA1.CSG_EXPLAIN. Is there a setting in SQL/PL that I can direct it to use this table instead of the normal PLAN_TABLE when I want to run an Explain plan?
thanks

 

[ADG]

da bull, can you create a private synonym called PLAN_TABLE for DBA1.CSG_EXPLAIN? That might work.

AG