Can I run Explain Plan with my own Plan table?

[pwo1433]

I have v 7.0.2.1076.
It takes the Explain Plan window as long as several minutes to come back because of the number of users using it. Our DBA suggested I define a Plan table in my own schema and use it instead of the system one. He does this on the Toad product but doesn't know if PL/SQL DEV. allows for that. I've checked the Dev. Manual and don't see anything about setting-up my own Plan table. Anyone know if that can be done and how?
Thanks.
Paul

 

[CTzen]

Yes, you can. Script utlxplan.sql is located on your database server in $ORACLE_HOME/rdbms/admin/ directory.

 

[pwo1433]

Our DBA says this script is to create a plan table, which is what we did several days ago. Now our problem is not to create this table, but is how to let PL/SQL Developer use it instead of the default plan table. In TOAD, there is Option tab in the menu where you can configure your software. Is there an option in Dev. to point Explain Plan to use my plan table instead of the default one? I've looked in Preferences and elsewhere but don't see this option.

 

[CTzen]

You can create synonym plan_table in the schema you are using, that points to new plan table you've created. AFAIK, there is no config parameter in PLD similar to TOAD's one.

 

[Marco Kalter]

There is indeed no configuration option for this. You will have to use the standard Oracle concept of public or private synonyms.

 

[pwo1433]

OK.
Thanks everybody.
Paul

 

[William Robertson]

In 10g it might be simpler just to make PLAN_TABLE a public synonym for SYS.PLAN_TABLE$, which is a global temporary table.