Feature Request -- Specify "plan_table" Schema

[darryl_staflund]

Hi there,

Would it be possible to modify the Explain Plan feature of PL/SQL Developer so that we can specify the preferred "plan_table" schema that we would like to work with? The default, at present, is to work with the plan_table of the user's schema and, if it isn't present, prompt the user to create the plan_table in that schema. Although this normally hasn't been a problem for me, our current database is about to go into production and I'd prefer to work with the plan_table of the SYS table instead of creating one in the production schema and raise eyebrows with the development staff.

Thank you.

Darryl

 

[Marco Kalter]

This is more or less possible. If you create a public synonym plan_table for sys.plan_table, or if the user creates a private plan_table synonym like this, it should work as described.