I am trying to find the toadprep.sql file in order to setup plan_table, but I am not able to find it.
The toadprep.sql file is no longer needed to set up plan tables. Now you can run the script from within Toad.
In versions prior to 9.0:
Go to Tools | Server Side Objects Wizard to run the scripts to set up your plan table. If you need instructions to navigate through the server side objects wizard please look in help for "Accessing the Server Side Install Wizard" and "Selecting Objects".
In version 9.0 and after:
Go to View | Toad Options | Oracle - General and click the button after the Schema and Table fields in the Explain Plan section. This will allow you to find an already created Plan Table or create a new one.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center