RE: Slow connection to DB when using TOAD

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Thu, 19 Feb 2004 11:13:24 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C19D9@xchgbrsm1.corp.espn.pvt>

Toad checks for a lot of stuff ... last time I noticed it was when TOAD = was selecting from DBA_TYPES view and in 9i earlier releases this was = *very* slow.

Do this ...
0. delete <your_toad_dir>\temps\debug.txt file ...=20 1. when you have TOAD up, go to Tools|Spool SQL| and choose spool to = file option
2. exit toad=20
3. restart toad

when toad comes up then you navigate to <your_toad_dir>\temps directory = and look for debug.txt ... it will have all the statements toad executes = with timestamp ... it will help you find out which one is taking the = longest.

You can also turn off the option to refresh users/tables list on logon = ...

Raj

-------------------------------------------------------------------------=

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of babette.turnerunderwood_at_hrdc-drhc.gc.ca
Sent: Thursday, February 19, 2004 11:08 AM To: oracle-l_at_freelists.org
Subject: Slow connection to DB when using TOAD

We are having noticeably slow connections to the database when using = TOAD.
>From our PC, using SQL*Plus, the connection to the database is 1second.
Using TOAD, the connection is 20-30 seconds and can be several minutes = when we are having slow DB performance.
Oracle 8.1.7.4 on MVS OS/390 v2.10

I know that TOAD does some processing when you make a connection. Is there any way to disable this processing ? Or configure it?

Thanks
Babette

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Feb 19 2004 - 10:13:24 CST