Error received when executing the Explain Plan:
"execution plan not available for this statement"
Toad user must set up the explain plan tables using the Server Side Objects Wizard. Please note that DBA privileges are required to setup Server Side Objects Wizard.
1] Select Tools | Server Side Object Wizard | Install, upgrade, or remove objects for all users to share click | click Next.
2] Leave the first option selected and enter the username, password and database name, then click Next.
3] From this page you want to select the Explain Plan, then click Next.
4] Click Next on the Toad Space Manager screen.
5] Select the default Tablespaces, then click Next.
6] On the next screen you have the option to either Save script, Run script or select the location to save the script to, then click Run script | select a password for the Toad User click OK, then click Next.
7] Click Next and close the Server Side Object Wizard in the last screen. Restart Toad.