# Auto Optimize SQL **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 10, 2023, 6:31pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133 "2023-03-10T18:31:51Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![lbello](https://avatars.discourse-cdn.com/v4/letter/l/b2d939/32.png) [@lbello](https://forums.toadworld.com/u/lbello)\ **Post date:** [March 10, 2023, 6:31pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/1 "2023-03-10T18:31:51Z")
Unable to load Quest SQL Optimizer for Oracle engine. This error appears when clicking the "Auto Optimize SQL" button in TOAD for Oracle ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 10, 2023, 6:40pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/2 "2023-03-10T18:40:40Z")
What version of Toad and what is the error? ---
**Author:** ![lbello](https://avatars.discourse-cdn.com/v4/letter/l/b2d939/32.png) [@lbello](https://forums.toadworld.com/u/lbello)\ **Post date:** [March 10, 2023, 7:02pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/3 "2023-03-10T19:02:53Z")
version 11.0.0.116 This error "Unable to load Quest SQL Optimizer for Oracle engine." ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 10, 2023, 7:06pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/4 "2023-03-10T19:06:40Z")
Wow, That's very old and out of support. Did it ever work? You can try the following... Verify that these files are in Toad's installation folder. - ConnPoolLib.dll - LogEngine.dll - QOraOptEngineLib.dll - QTScanLib.dll - XpertTrace.dll - OptimizerEngine.exe If any are missing, re-run the Toad installer and use the Repair option. If all of those files are present then... 1. Open Toad 2. Go to _ **View \> Toad Options...** _ 3. Go to the _ **General** _ page 4. Check the _ **Application logs** _ checkbox 5. Restart Toad 6. Reproduce the problem 7. Zip and supply the .txt log files You can send them to me in direct message if you'd like. The log files are going to be located in Toad's appdata\SQLTuning folder. On the General page in Toad Options there's an _ **Application data directory** _ box that tells you where Toad's appdata folder is located. Only the .txt files are necessary. Nothing in the "Session..." folders is useful. ---
**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\ **Post date:** [March 10, 2023, 7:08pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/5 "2023-03-10T19:08:11Z")
Correction to the above... enabling logs via options is new. You'll need to manually edit Toad.ini with Toad closed. Locate the [SETTINGS] section and add _ **DEBUG=1** _ to it. First, search for _ **DEBUG** _ and if it exists then just update its value. ---
**Author:** ![lbello](https://avatars.discourse-cdn.com/v4/letter/l/b2d939/32.png) [@lbello](https://forums.toadworld.com/u/lbello)\ **Post date:** [March 13, 2023, 1:36pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/6 "2023-03-13T13:36:15Z")
Toad 11 It's very old but it worked until I uninstalled "SQL Optimizer" to upgrade it. I already added degug=1 in toad.ini What is the next step? Regards ---
**Author:** ![lbello](https://avatars.discourse-cdn.com/v4/letter/l/b2d939/32.png) [@lbello](https://forums.toadworld.com/u/lbello)\ **Post date:** [March 13, 2023, 1:39pm UTC](https://forums.toadworld.com/t/auto-optimize-sql/57133/7 "2023-03-13T13:39:49Z")
Are all the files dll y exe