# Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [September 5, 2013, 1:48am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603 "2013-09-05T01:48:59Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![martin.berger](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@martin.berger](https://forums.toadworld.com/u/martin.berger)\ **Post date:** [September 5, 2013, 1:48am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/1 "2013-09-05T01:48:59Z")
Hello I have Toad 12.0.0.61 64bit fresh installed on Windows 7 64 bit Notebook Lenovo W510 (32Gb Memory). I have local Oracle 11.2.0.3/12.1.0.1 databases up and running (small dbs, only 1GB each). When I start new connection by SQL\*Plus, the connection is open until milliseconds. When I start a new Toad connection to one of this databases, the duration is over 6 seconds. Oracle client version which Toad is using is 11.2.0.3. I have already done: - gathered statistics - unchecked “highlight table/view/stored procedure names” - check for DBA view access - SQL Statements to save - Toad Advisor Tips - etc. And all what is described in post [http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx](http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx) Also the GUI seems to be slower than Toad 11. The Windows sometimes hangs for some milliseconds until they are open. In the Toad menubar i have the message [no response] and after some waits, the windows are open. Any help is very appreciated. Regards, Martin ---
**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\ **Post date:** [September 5, 2013, 3:45am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/2 "2013-09-05T03:45:06Z")
Martin, There is a patch available via support for that version (to 12.1). Many of the issues you're seeing were addressed there. Let us know if you're still having issues after upgrading. Thanks, Greg On Sep 5, 2013, at 4:50 AM, "martin.berger" [bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com) wrote: > **[Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/k8dpt8xtxk6orowb7t9zq9/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx)** > Thread created by martin.berger > Hello > I have Toad 12.0.0.61 64bit fresh installed on Windows 7 64 bit Notebook Lenovo W510 (32Gb Memory). I have local Oracle 11.2.0.3/12.1.0.1 databases up and running (small dbs, only 1GB each). When I start new connection by SQL\*Plus, the connection is open > until milliseconds. When I start a new Toad connection to one of this databases, the duration is over 6 seconds. Oracle client version which Toad is using is 11.2.0.3. > I have already done: > - gathered statistics > - unchecked "highlight table/view/stored procedure names" > - check for DBA view access > - SQL Statements to save > - Toad Advisor Tips > - etc. > And all what is described in post [http://gyk.r.mailjet.com/redirect/xms2hb6wtpbb0jotlt6pr1/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx](http://gyk.r.mailjet.com/redirect/xms2hb6wtpbb0jotlt6pr1/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx) > Also the GUI seems to be slower than Toad 11. The Windows sometimes hangs for some milliseconds until they are open. In the Toad menubar i have the message [no response] and after some waits, the windows are open. > Any help is very appreciated. > Regards, Martin > To reply, please reply-all to this email. > > [Stop receiving emails](http://gyk.r.mailjet.com/redirect/9hgnt79q3smx31zz7b4sxp/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?subscribe=false) on this subject. > > Or [ > Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/cghwt56p2gn5t9299c8cgt/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. > > Toad for Oracle - Discussion Forum > [Flag](http://gyk.r.mailjet.com/redirect/wlbph1ogql3yrc17bn49zg/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?AbuseContentId=ad99234b-7973-4f03-94b7-30ab38042e8b&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) > this post as spam/abuse. > ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif) ---
**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:** [September 5, 2013, 6:45am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/3 "2013-09-05T06:45:08Z")
When you make a connection in SQL_Plus, all SQL_Plus does is make the connection. It does not run queries behind the scenes to determine what your privileges are, what windows can be displayed, etc. Toad has to do a lot of things besides just make the connection. It runs queries to determine: a) System privileges b) Default roles c) Database character set d) instance and server name e) Authentication type f) Oracle version g) If java is installed h) If you have privs to execute dbms\_debug i) If Code tester is installed. If so, which version j) If Team coding is installed k) If you are connected to a RAC instance l) If you are connected to an Amazon RDS instance m) If Code Xpert tables are installed n) If you are restricted by Toad Security o) Direct grants on DBA\_ views, if “Check for access to dba views” is checked, but you don’t have any role or system privilege that would give you such privileges p) Schema names (based on options – all, only users with objects, etc) Then if you have any windows set to auto-open, such as Schema Browser or Editor, those windows have some queries of their own to run. So it really isn’t fair to compare Toad’s connection time to SQL\*Plus’s connection time. Toad is probably connecting just as fast, but all this other stuff takes time too. Now, all that said….when you say “6 seconds”….if you are timing that from the moment you click on Toad, and then it starts and autoconnects….6 seconds is about right. If Toad is already running and you just make a connection (with no windows auto-opening), if you have a reasonably fast, local database, that should take only about 1 second. If it is taking longer, you can turn on spool sql to see what Toad is doing and maybe isolate the slowest running query, if one stands out. I’ll be happy to look at spool sql output if you post it. I have also seen cases where the installation of an additional Oracle client can slow down the initial connection time. But for me, when that happens, it slows things down much more than 6 seconds. **From:** martin.berger [[mailto:bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com)] **Sent:** Thursday, September 05, 2013 3:51 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [Toad for Oracle - Discussion Forum] Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **[ Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/k8dpt8xtxk66powb7t2nsz/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx)** Thread created by martin.berger Hello I have Toad 12.0.0.61 64bit fresh installed on Windows 7 64 bit Notebook Lenovo W510 (32Gb Memory). I have local Oracle 11.2.0.3/12.1.0.1 databases up and running (small dbs, only 1GB each). When I start new connection by SQL\*Plus, the connection is open until milliseconds. When I start a new Toad connection to one of this databases, the duration is over 6 seconds. Oracle client version which Toad is using is 11.2.0.3. I have already done: - gathered statistics - unchecked “highlight table/view/stored procedure names” - check for DBA view access - SQL Statements to save - Toad Advisor Tips - etc. And all what is described in post [http://gyk.r.mailjet.com/redirect/xms2hb6wtpbvcjotltb46k/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx](http://gyk.r.mailjet.com/redirect/xms2hb6wtpbvcjotltb46k/www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2008/09/10/speed-up-toad-updated.aspx) Also the GUI seems to be slower than Toad 11. The Windows sometimes hangs for some milliseconds until they are open. In the Toad menubar i have the message [no response] and after some waits, the windows are open. Any help is very appreciated. Regards, Martin To reply, please reply-all to this email. [Stop receiving emails](http://gyk.r.mailjet.com/redirect/9hgnt79q3sm3b1zz7bvz5k/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/cghwt56p2gnpo9299cpngj/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/wlbph1ogql31pc17bns4q6/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?AbuseContentId=ad99234b-7973-4f03-94b7-30ab38042e8b&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/1bbeb81e/4HKn6y.gif) ---
**Author:** ![martin.berger](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@martin.berger](https://forums.toadworld.com/u/martin.berger)\ **Post date:** [September 9, 2013, 9:17am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/4 "2013-09-09T09:17:04Z")
Hi John Thank you for your answer. I have a fast local database on a SSD. Can you explain me where to enable the spooling of the Toad login sql? Regards, Martin ---
**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:** [September 9, 2013, 9:20am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/5 "2013-09-09T09:20:54Z")
From the main menu: Database -\> Spool SQL -\> Spool to Screen. **From:** martin.berger [[mailto:bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com)] **Sent:** Monday, September 09, 2013 11:18 AM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **[ RE: Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/f9rhhhtbr0l4w5tp4r2ool/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41123.aspx#41123)** Reply by martin.berger Hi John Thank you for your answer. I have a fast local database on a SSD. Can you explain me where to enable the spooling of the Toad login sql? Regards, Martin To reply, please reply-all to this email. [Stop receiving emails](http://gyk.r.mailjet.com/redirect/shh6tto6npfs215bnb9n0s/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/0b6phf5dj4pvjr6dgyj9yx/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/jm5lt721bq3pwq2rhkkjkt/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41123.aspx?AbuseContentId=cf4ec42d-84dd-4a94-b73c-5df331b8ee9e&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/09ceea7f/4L5ONw.gif) ---
**Author:** ![martin.berger](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@martin.berger](https://forums.toadworld.com/u/martin.berger)\ **Post date:** [September 9, 2013, 10:16am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/6 "2013-09-09T10:16:00Z")
I have enabled spooling, but the inital (first) connect which is so slow is not traced. It looks for me that the first connection is slower than the second,third etc. to same database. Is it possible to trace the first connect? Regards, Martin ---
**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:** [September 9, 2013, 10:25am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/7 "2013-09-09T10:25:54Z")
This may sound like a dumb question, but are you enabling spooling before you attempt to make the first connection? If you have autoconnect set up on the login screen, you’ll have to turn that off temporarily. If that’s not it, then I don’t know why it wouldn’t show connect info. So it is just the connection that’s not being traced, but the queries after the connection is made are being traced? If the queries all seem fast, but the initial connection is slow, then it doesn’t sound like the problem is within Toad. I know you said SQL\*Plus always connects fast….is it using the same Oracle Home as Toad? **From:** martin.berger [[mailto:bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com)] **Sent:** Monday, September 09, 2013 12:17 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **[ RE: Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/fvq1tgh2m5v23nddz0jfdp/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41129.aspx#41129)** Reply by martin.berger I have enabled spooling, but the inital (first) connect which is so slow is not traced. It looks for me that the first connection is slower than the second,third etc. to same database. Is it possible to trace the first connect? Regards, Martin To reply, please reply-all to this email. [Stop receiving emails](http://gyk.r.mailjet.com/redirect/jlrrhpsxqr6d8cmn03k7gz/www.toadworld.com/products/toad-for-oracle/f/10/t/20265.aspx?subscribe=false) on this subject. Or [ Unsubscribe from Toad for Oracle - General](http://gyk.r.mailjet.com/redirect/kn67hldthtblghsbw0mcgr/www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether. Toad for Oracle - Discussion Forum [Flag](http://gyk.r.mailjet.com/redirect/w7sch18pz7mt4d31gs9gsm/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41129.aspx?AbuseContentId=1ead8bea-3fa3-4a56-81dc-af3fd72f72c0&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse. ![](http://gyk.r.mailjet.com/4bbc2ed4/4L8wJF.gif) ---
**Author:** ![martin.berger](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@martin.berger](https://forums.toadworld.com/u/martin.berger)\ **Post date:** [September 9, 2013, 10:48am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/8 "2013-09-09T10:48:23Z")
Now I have understand what you mean - Toad is spooling. Here is the output from the spool action - can you see some significant waits? The biggest time difference is here: * * * Session: [SYS@CGM.TRIVADISTRAINING.COM](mailto:SYS@CGM.TRIVADISTRAINING.COM) Timestamp: 19:44:09.135 SELECT u.NAME FROM sys.USER$ u WHERE u.TYPE# = 1 ORDER BY 1 * * * Session: [SYS@CGM.TRIVADISTRAINING.COM](mailto:SYS@CGM.TRIVADISTRAINING.COM) Timestamp: 19:44:13.072 DECLARE TYPE table\_names IS VARRAY (3) OF VARCHAR2 (30); currval\_not\_defined EXCEPTION; PRAGMA EXCEPTION\_INIT (currval\_not\_defined, -8002); sys\_prof\_valid NUMBER; toad\_prof\_valid NUMBER; rst NUMBER; sys\_pack VARCHAR2 (17); prof\_seq VARCHAR2 (24); tables table\_names; dbms\_prof\_tables CONSTANT table\_names := table\_names (‘plsql\_profiler\_data’, ‘plsql\_profiler\_runs’, ‘plsql\_profiler\_units’) ; dbms\_hprof\_tables CONSTANT table\_names := table\_names (‘dbmshp\_runs’, ‘dbmshp\_function\_info’, ‘dbmshp\_parent\_child\_info’) ; ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [September 9, 2013, 10:55am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/9 "2013-09-09T10:55:55Z")
On another topic – WHY are you connecting as SYS ??? [http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/08/12/common-toad-security-connection-mistakes.aspx](http://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/08/12/common-toad-security-connection-mistakes.aspx) Unless you’re running an oracle script from ?\rdbms\admin directory that requires SYS or starting/stopping instance via instance manager – there’s no reason to use the SYS account. That’s supposed to be like root on Unix – you don’t use it unless you have a darn good reason …. **From:** martin.berger [[mailto:bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com)] **Sent:** Monday, September 09, 2013 12:49 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **[ RE: Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/vodthzlcchnx41m11jr02h/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41132.aspx#41132)** Reply by martin.berger Now I have understand what you mean - Toad is spooling. Here is the output from the spool action - can you see some significant waits? The biggest time difference is here: * * * Session: [SYS@CGM.TRIVADISTRAINING.COM](mailto:SYS@CGM.TRIVADISTRAINING.COM) Timestamp: 19:44:09.135 SELECT u.NAME FROM sys.USER$ u WHERE u.TYPE# = 1 ORDER BY 1 ---
**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:** [September 9, 2013, 11:05am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/10 "2013-09-09T11:05:55Z")
The query against sys.user$ should execute very quickly, so I don’t think it is the problem. If you have tens of thousands of users, that might slow things down a bit here as Toad processes all those records, but somehow I doubt that is what’s happening here. That pl/sql block is executed by the Editor when it opens. So it sounds like you have the Editor configured to auto-open when a connection is made, and maybe the Editor is opening slowly for some reason. As a test, try disabling the auto-opening of the Editor (in Options -\> Windows) and see if that helps your connection times. If it does, you may have a large sql history file or something like that which is causing the Editor to open slowly. **From:** martin.berger [[mailto:bounce-martinberger@toadworld.com](mailto:bounce-martinberger@toadworld.com)] **Sent:** Monday, September 09, 2013 12:49 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** RE: [Toad for Oracle - Discussion Forum] Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow **[ RE: Toad 12 very slow initial connection - already tried the tips in the posts / GUI slow](http://gyk.r.mailjet.com/redirect/j85wtp87drlv7n6ws4yxwn/www.toadworld.com/products/toad-for-oracle/f/10/p/20265/41132.aspx#41132)** Reply by martin.berger Now I have understand what you mean - Toad is spooling. Here is the output from the spool action - can you see some significant waits? The biggest time difference is here: * * * Session: [SYS@CGM.TRIVADISTRAINING.COM](mailto:SYS@CGM.TRIVADISTRAINING.COM) Timestamp: 19:44:09.135 SELECT u.NAME FROM sys.USER$ u WHERE u.TYPE# = 1 ORDER BY 1 ---
**Author:** ![martin.berger](https://avatars.discourse-cdn.com/v4/letter/m/82dd89/32.png) [@martin.berger](https://forums.toadworld.com/u/martin.berger)\ **Post date:** [September 9, 2013, 11:37am UTC](https://forums.toadworld.com/t/toad-12-very-slow-initial-connection-already-tried-the-tips-in-the-posts-gui-slow/26603/11 "2013-09-09T11:37:57Z")
Hi John After disabling the auto-opening, the connection is created in half of a second. My issue seems to be in the editor.