When the 'Connect' button is clicked, Toad makes a connection and then runs a series of SQL statements in the background to populate the various modules e.g. Schema Browser. To determine whether the slow 'connection' is due to the actual connection time or running the background queries, do the following steps:
1. From the login window, click the 'Add Login Record' or select an existing connection and click 'Edit Login Record'
2. Complete the login details
3. Click the 'Test' button
4. Once a connection is established Toad will display a window with 'Success: Connection time nnn ms/sec'
Note: The TEST button only makes a connection and doesn’t execute the background post-connection queries. From this you should be able to determine whether the issue lies on connection itself or the background queries Toad is running. If connection time is long, then this may be Oracle Client or Network related. Please contact your DBA or Network Admin for assistance.
If test connection time is short, but actual connection time is much longer then try running SQL Tracker to determine which query is causing the bottleneck.
How to use SQL Tracker (video)
