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

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 23 Jan 2003 09:15:04 -0800
Message-ID: <F001.00538A4B.20030123091504@fatcity.com>

I had a similar problem once that was solved by editing my SQLNET.ORA file. I set:

SQLNET.AUTHENTICATION_SERVICES= (None)

...instead of:

SQLNET.AUTHENTICATION_SERVICES= (NTS) I'm not sure what functionality this change eliminated, but my connection times are sure a lot faster now.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:

- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London

-----Original Message-----

Sent: Thursday, January 23, 2003 9:14 AM To: Multiple recipients of list ORACLE-L

Hi Tim, and Steve,

Thanks for the comments. I did check whether tracing was enabled, and it wasn't..

Thanks for the thought though.

Cheers

Mark

-----Original Message-----

Stephen
Sent: 23 January 2003 13:49
To: Multiple recipients of list ORACLE-L

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


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

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


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

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

--

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

Author: Cary Millsap
INET: cary.millsap_at_hotsos.com

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