TOAD SQL Optimizer not working
Keith Wyatt <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <29432503.1334601324390409656.JavaMail.SYSTEM@alvqcfw02> |
Message from: Keith1999 I've used the SQL Optimizer before but today it simply refuses to work. I've tried rebooting, etc. and have the same results. Steps... Within SQL Editor window highlight SQL code Right click -> Optimize -> Optimize Current SQL Database type = General (OLTP or mixed) Search Depth = 1 (also tried 2) <slider control> Hit OK Button Optimizer opens within TOAD IDE. Explain Plan completes Work starts to optimize Then after a few seconds it errors Error window popup... "Failed to update scenario data file Error adding SQL" Press OK to clear popup Popup re-appears MANY MANY times After all errors cleared no alternative SQL to choose from, only Original SQL present within optimizer tab/window Additional info... Toad Version: 10.6.1.3 (Toad for Oracle Xpert) Used simple SQL and more complex SQL, same result Does anyone know where this "scenario data file" is so I can check the file access rights, etc? Many thanks _______________________________________ Historical Messages Author: Keith Wyatt Date: Tue Dec 20 06:12:59 PST 2011 I've used the SQL Optimizer before but today it simply refuses to work. I've tried rebooting, etc. and have the same results. Steps... Within SQL Editor window highlight SQL code Right click -> Optimize -> Optimize Current SQL Database type = General (OLTP or mixed) Search Depth = 1 (also tried 2) <slider control> Hit OK Button Optimizer opens within TOAD IDE. Explain Plan completes Work starts to optimize Then after a few seconds it errors Error window popup... "Failed to update scenario data file Error adding SQL" Press OK to clear popup Popup re-appears MANY MANY times After all errors cleared no alternative SQL to choose from, only Original SQL present within optimizer tab/window Additional info... Toad Version: 10.6.1.3 (Toad for Oracle Xpert) Used simple SQL and more complex SQL, same result Does anyone know where this "scenario data file" is so I can check the file access rights, etc? Many thanks __ _______________________________________