Allegedly, TOAD only works if kissed by a beautiful princess. On 02/24/2004 04:14:50 PM, oracle-l-bounce@xxxxxxxxxxxxx wrote: > I tried searching the TOAD list archives that > Jacques recommended. And I tried this below. > However, I never create a "debug.txt" file > Or anything that looks like it. > > I also looked at all of the tool configuration options > (twice) and cannot find anything for turning off > "refresh users/tables list on logon" > > Any other suggestions ? > > Thanks > Babette > > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On > Behalf Of Jamadagni, Rajendra > Sent: 2004-02-19 11:13 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: Slow connection to DB when using TOAD > > > 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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of > babette.turnerunderwood@xxxxxxxxxxxxxxx > Sent: Thursday, February 19, 2004 11:08 AM > To: oracle-l@xxxxxxxxxxxxx > 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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------