When you make a connection in SQLPlus, all SQLPlus 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:
Database character set
instance and server name
If java is installed
If you have privs to execute dbms_debug
If Code tester is installed. If so, which version
If Team coding is installed
If you are connected to a RAC instance
If you are connected to an Amazon RDS instance
If Code Xpert tables are installed
If you are restricted by Toad Security
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
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:email@example.com]
Sent: Thursday, September 05, 2013 3:51 AM
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
Thread created by martin.berger
I have Toad 184.108.40.206 64bit fresh installed on Windows 7 64 bit Notebook Lenovo W510 (32Gb Memory). I have local Oracle 220.127.116.11/18.104.22.168 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 22.214.171.124.
I have already done:
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.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.