# TOAD SQL Optimizer not working **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [December 20, 2011, 8:12am UTC](https://forums.toadworld.com/t/toad-sql-optimizer-not-working/10937 "2011-12-20T08:12:59Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Keith1999](https://avatars.discourse-cdn.com/v4/letter/k/4da419/32.png) [@Keith1999](https://forums.toadworld.com/u/Keith1999)\ **Post date:** [December 20, 2011, 8:12am UTC](https://forums.toadworld.com/t/toad-sql-optimizer-not-working/10937/1 "2011-12-20T08:12:59Z")
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) 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 ---
**Author:** ![Keith1999](https://avatars.discourse-cdn.com/v4/letter/k/4da419/32.png) [@Keith1999](https://forums.toadworld.com/u/Keith1999)\ **Post date:** [December 20, 2011, 10:42am UTC](https://forums.toadworld.com/t/toad-sql-optimizer-not-working/10937/2 "2011-12-20T10:42:52Z")
I have updated/patched to the new version of SQL Optimizer v8.5.0 Successful install Reboot Retried query optimize with same error result Download link for patch… [https://support.quest.com/Search/SearchDownloads.aspx?dsNav=Ns:P\_DateLastModifiedSortable|101|-1|,N:268440217&Dt=Quest%20SQL%20Optimizer%20for%20Oracle](https://support.quest.com/Search/SearchDownloads.aspx?dsNav=Ns:P_DateLastModifiedSortable%7C101%7C-1%7C,N:268440217&Dt=Quest%20SQL%20Optimizer%20for%20Oracle) ---
**Author:** ![Keith1999](https://avatars.discourse-cdn.com/v4/letter/k/4da419/32.png) [@Keith1999](https://forums.toadworld.com/u/Keith1999)\ **Post date:** [December 20, 2011, 11:20am UTC](https://forums.toadworld.com/t/toad-sql-optimizer-not-working/10937/3 "2011-12-20T11:20:52Z")
This fault is not caused by Toad or any Quest related product. I noticed that our network administrator had modified “Symantec Backup Exec Desktop Agent” to monitor the directory branch… c:\Users\\AppData\ which includes… c:\Users\\AppData\Roaming\Quest Software I ‘exited’ the Symantec Backup Agent and the optimizer went through without any problems. I will exclude the following directory from the backup monitor… C:\Users\keiwya\AppData\Roaming\Quest Software\Quest SQL Optimizer for Oracle If that doesn’t work then I’ll just exclude the following (which is less desirable) c:\Users\\AppData\Roaming\Quest Software Is there anyone from Quest that can give an official recommendation for this please? ---
**Author:** ![Mark\_Lerch](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_lerch/32/33_2.png) [@Mark\_Lerch](https://forums.toadworld.com/u/Mark_Lerch)\ **Post date:** [December 20, 2011, 1:01pm UTC](https://forums.toadworld.com/t/toad-sql-optimizer-not-working/10937/4 "2011-12-20T13:01:19Z")
I doubt you’re going to find anyone at Quest to give an official recommendation on ending the use of antivirus software for specific directories, for obvious legal reasons. This isn’t the place where they would do so anyway, being principally a user forum. I despise “anti” virus software, personally, and try to dodge out of it wherever possible. More often than not it acts like a virus instead of an “anti-virus.”