RE: Slow connection to DB when using TOAD
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Feb 2004 16:14:50 -0500
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
-----------------------------------------------------------------
Other related posts:
