Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLAN TABLE

615305Jan 22 2008 — edited Jan 23 2008
To see the current statement getting executed im using the session browser utility in TOAD. And to find the plan of the query im going to the view plan tab. But in that tab it saying the plan table is not available. I created the plan table from $ORACL_HOME/rdbms/admin/utlxplan.sql for the user. But even then im not able to see tha explain plan.

I also changed the plan table in TOAD from TOAD_PLAN_TABLE to PLAN_TABLE in view-->options-->General. But still im not able to see the explain plan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2008
Added on Jan 22 2008
7 comments
559 views