Oracle-L: RE: Slow SQL*Plus connect.

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 23 Jan 2003 05:48:59 -0800
Message-ID: <F001.0053848D.20030123054859@fatcity.com>

I would also verify that Oracle Trace is turned off and that within $ORACLE_HOME/otrace/admin there are no files.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Wednesday, January 22, 2003 11:49 AM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Slow SQL*Plus connect.

How big is the listener log file?? do you truncate/rename it on regular basis??
just a thought.

Sunil Nookala
Dell Corp.

-----Original Message-----
Sent: Wednesday, January 22, 2003 4:09 AM To: Multiple recipients of list ORACLE-L

Hi All,

We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K machine, and I was wondering if anybody else had experienced these slow connection times as well? We have also been asked lately by a number of customers about slow connection times, and to this point haven't found a solution for either ourselves or our contacts..

It's not a network issue as connection times take just as long "locally". Connections can take up to around a minute (and the odd occasion a couple of minutes). No MTS is in use.

OS's that I've heard about this on are Win2K, XP and NT so I'm also wondering if it may be a Win32 issue.

Help!

Cheers :)

Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

--

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

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

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

Author:
INET: Sunil_Nookala_at_Dell.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

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

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------