RE: Slow connection to DB when using TOAD
- From: "M Rafiq" <rafiq9857@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Feb 2004 16:53:18 -0500
Pete,
There are 2 now. Don't forget Lisa Rutland , goddess No. 2 . Lisa please
don't mind for using your maiden name ....
Regards
Rafiq
From: Pete Sharman <peter.sharman@xxxxxxxxxx>
Reply-To: oracle-l@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
CC: "Peter Ross. Sharman" <PETER.SHARMAN@xxxxxxxxxx>
Subject: RE: Slow connection to DB when using TOAD
Date: Wed, 25 Feb 2004 08:39:09 +1100
Settle for a goddess? We've got one of them. :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mladen Gogala
Sent: Wednesday, February 25, 2004 8:28 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Slow connection to DB when using TOAD
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
_________________________________________________________________
Watch high-quality video with fast playback at MSN Video. Free!
http://click.atdmt.com/AVE/go/onm00200365ave/direct/01/
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts: