PLAN TABLE
615305Jan 22 2008 — edited Jan 23 2008To 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