![]() In file UTLXPLAN.SQL (this file is executed for each schema owner), click the Oracle RDBMS plan table (found in \RDBMS\admin) This, among other things, builds the TOAD_PLAN_TABLE. The solution is to run the script TOADPREP.SQL as defined in Chapter 1 and ![]() The problem is that the TOADPREP.SQL script has not been run as described inĬhapter 1, or the TOAD explain plan table has been renamed. If you get the error ORA-02404 Specified Plan Table Not Found as shown Cost-based hints can easilyīe added by using the SQL Templates option (discussed earlier in this ![]() Statement and selecting the Optimizer Mode option. TOAD does support changing the Optimizer Mode by right-clicking on the SQL Plans and the various features of the rule- and cost-based Oracle optimizers. It is beyond the scope of this book to provide a basic explanation of explain
0 Comments
Leave a Reply. |