-
execution plan
hi
i m using TOAD 8.5
when i want it to display execution plan for a query using SCOTT schema it gives me error
ORA-02404: specified plan table not found
i have created PLAN_TABLE in the scott schema and also in system schema and used different methods of this kind but still receiving error
kindly tell me how to use this option of TOAD
if i use SQLPLUs, PLAN_TABLE is working fine
Regards
-
By default, TOAD uses a plan table of a different name (TOAD_PLAN_TABLE). You can change this in the view/options/oracle in TOAD.
-