# Reset SQL Optimizer call from Toad **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [April 15, 2015, 5:45am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126 "2015-04-15T05:45:15Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 15, 2015, 5:45am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/1 "2015-04-15T05:45:15Z")
Hi, Toad 12.x x64 I have installed SQL Optimizer beta 9.0. Then from Toad call it, setting as default option beta SQL Optimizer in dialog (when prompt to choose between versions regular and beta). SQL Optimizer is expired and now I cannot reset the value. Any hint where this parameter is written or how to reset just it to show to Licensed 8.9.1 version. Brg Damir ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 16, 2015, 1:37am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/2 "2015-04-16T01:37:17Z")
Please this is quite urgent problem and any help would be appreciated. ---
**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\ **Post date:** [April 16, 2015, 5:12am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/3 "2015-04-16T05:12:44Z")
This sounds like a SQL Optimizer issue, not a Toad one. Have you tried to post this issue on their board? **From:** Damir Vadas [[mailto:bounce-damirvadas\_250@toadworld.com](mailto:bounce-damirvadas_250@toadworld.com)] **Sent:** Thursday, April 16, 2015 4:38 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Reset SQL Optimizer call from Toad **[RE: Reset SQL Optimizer call from Toad](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53523.aspx#53523)** Reply by Damir Vadas Please this is quite urgent problem and any help would be appreciated. To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24368.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53523.aspx?AbuseContentId=02c5549a-bc15-4be4-a9db-16b952381aa3&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 16, 2015, 5:15am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/4 "2015-04-16T05:15:29Z")
Have you tried uninstalling the expired beta? ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 16, 2015, 5:19am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/5 "2015-04-16T05:19:59Z")
@Brad, No this is Toad issue because Toad is calling SQL Optimizer defined in Toad dialog … so there is some kind of settings saved somewhere… @John, I cannot do that on client machine (have no admin rights) and user cannot ask for help to admin level because this will be a security issue-someone installed beta software on company comp… So I was asked for help. Looking forward to get some info…doesn’t really seems to be hard if you know where to look for. Hope now is all more clear. ---
**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\ **Post date:** [April 16, 2015, 5:26am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/6 "2015-04-16T05:26:44Z")
What do you mean by “defined in Toad dialog”? How exactly are you calling SQL Optimizer from Toad? **From:** Damir Vadas [[mailto:bounce-damirvadas\_250@toadworld.com](mailto:bounce-damirvadas_250@toadworld.com)] **Sent:** Thursday, April 16, 2015 8:20 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Reset SQL Optimizer call from Toad **[RE: Reset SQL Optimizer call from Toad](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53526.aspx#53526)** Reply by Damir Vadas @Brad, No this is Toad issue because Toad is calling SQL Optimizer defined in Toad dialog … so there is some kind of settings saved somewhere… @John, I cannot do that on client machine (have no admin rights) and user cannot ask for help to admin level because this will be a security issue-someone installed beta software on company comp… So I was asked for help. Hope now is all more clear. To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24368.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53526.aspx?AbuseContentId=f59b2634-7bad-4fcc-b52f-34bc051db420&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 16, 2015, 5:32am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/7 "2015-04-16T05:32:43Z")
Hi Brad, Sorry for being unclear, but here is a picture ![Unbenannt.png](https://global.discourse-cdn.com/quest/original/2X/e/e9c64d9bd86350e0d28b6adb82e03b02e81292b7.png) And then user get: ![Unbenannt2.jpeg](https://global.discourse-cdn.com/quest/original/2X/b/b88b4f64a7ca94bb60ff21eb1816c3789baff320.jpeg) and in between there is no way dialog (in which he previously sadi that he will use beta version of SQL Optimizer and checked (I think) do not ask again). ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [April 16, 2015, 5:41am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/8 "2015-04-16T05:41:49Z")
I think that prompt to use the SQL Optimizer Beta came from SQL Optimizer, not Toad. I don’t see any such prompt in our source. ---
**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\ **Post date:** [April 16, 2015, 5:48am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/9 "2015-04-16T05:48:52Z")
My only suggestion at this point would be to locate SQL Optimizer’s user files and nuking them. Like you mentioned, maybe they are storing your preference somewhere **From:** Damir Vadas [[mailto:bounce-damirvadas\_250@toadworld.com](mailto:bounce-damirvadas_250@toadworld.com)] **Sent:** Thursday, April 16, 2015 8:33 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Reset SQL Optimizer call from Toad **[RE: Reset SQL Optimizer call from Toad](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53528.aspx#53528)** Reply by Damir Vadas Hi Brad, Sorry for being unclear, but here is a picture [![](http://www.toadworld.com/resized-image.ashx/ __size/550x0/__ key/communityserver-discussions-components-files/10/Unbenannt.png)](http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/10/Unbenannt.png) And then user get: [![](http://www.toadworld.com/resized-image.ashx/ __size/550x0/__ key/communityserver-discussions-components-files/10/Unbenannt2.JPG)](http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/10/Unbenannt2.JPG) and in between there is no way dialog (in which he previously sadi that he will use beta version of SQL Optimizer and checked (I think) do not ask again). To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24368.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53528.aspx?AbuseContentId=34b1ae8d-8e10-4b66-942c-d7221688a728&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://04j0.mj.am/o/04j0/f1aa640f/hqop24te.gif) ---
**Author:** ![ButtonPusher](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/buttonpusher/32/147_2.png) [@ButtonPusher](https://forums.toadworld.com/u/ButtonPusher)\ **Post date:** [April 16, 2015, 5:49am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/10 "2015-04-16T05:49:47Z")
\*\*If there is a safe way to do so. I don’t know how they operate. **From:** Brad Boddicker **Sent:** Thursday, April 16, 2015 8:48 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Reset SQL Optimizer call from Toad My only suggestion at this point would be to locate SQL Optimizer’s user files and nuking them. Like you mentioned, maybe they are storing your preference somewhere **From:** Damir Vadas [[mailto:bounce-damirvadas\_250@toadworld.com](mailto:bounce-damirvadas_250@toadworld.com)] **Sent:** Thursday, April 16, 2015 8:33 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Reset SQL Optimizer call from Toad **[RE: Reset SQL Optimizer call from Toad](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53528.aspx#53528)** Reply by Damir Vadas Hi Brad, Sorry for being unclear, but here is a picture [![](http://www.toadworld.com/resized-image.ashx/ __size/550x0/__ key/communityserver-discussions-components-files/10/Unbenannt.png)](http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/10/Unbenannt.png) And then user get: [![](http://www.toadworld.com/resized-image.ashx/ __size/550x0/__ key/communityserver-discussions-components-files/10/Unbenannt2.JPG)](http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/10/Unbenannt2.JPG) and in between there is no way dialog (in which he previously sadi that he will use beta version of SQL Optimizer and checked (I think) do not ask again). To reply, please reply-all to this email. [Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/24368.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/24368/53528.aspx?AbuseContentId=34b1ae8d-8e10-4b66-942c-d7221688a728&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://04j0.mj.am/o/04j0/f1aa640f/hqop24te.gif) ---
**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\ **Post date:** [April 16, 2015, 5:51am UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/11 "2015-04-16T05:51:51Z")
THX guys … case closed. Fail overing to SQL Optimizer forum soon … but first will “by myself” if I can find something. ---
**Author:** ![AlexLuk](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@AlexLuk](https://forums.toadworld.com/u/AlexLuk)\ **Post date:** [April 16, 2015, 7:33pm UTC](https://forums.toadworld.com/t/reset-sql-optimizer-call-from-toad/33126/12 "2015-04-16T19:33:57Z")
The option to control which edition/version to open up when launched from Toad is shared by all editions and versions of SQL Optimizer. It means that you can open any working copy of the product to change the default. In your case, please launch the licensed 8.9.1 SQL Optimizer, then click on Options. Under the General | Options page, there is a “Setting…” button on the bottom of the screen. Click that button and you will be able to change your default.