RE: slow sqlnet connections

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Thu, 10 Jan 2002 13:20:49 -0800
Message-ID: <F001.003ED13A.20020110130132@fatcity.com>

Check the server Oracle Home/otrace/admin directory to see if you have any *.dat files. If so, then Oracle Trace is turned on and that will slow all connections down. Also check to see if any SQL*Net tracing is turned on, especially at the client level. Finally, look at the port and see if unusual traffic is being transmitted through it.

Thank You

Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

-----Original Message-----
Sent: Thursday, January 10, 2002 3:42 PM

To:     Multiple recipients of list ORACLE-L
Subject:        slow sqlnet connections

I'm working on verifying things before an upgrade of our 8162 databases to 8172 and have been getting complaints of very slow sqlnet connections - near

client application hangs, in fact. The users are still coming in through the
8162 listener to the 8172 test database. I suspect that the problem might be
in the sqlnet layer since I can connect to the database at the host and run selects with no apparent slowdown. I set up an 8172 listener on a separate

port to get some users to test that configuration. I'll know more tomorrow,

but thought I'd throw this out to the lists to see if anyone has any suggestions. The server is on Compaq Tru64; clients on Windows 2000.

Thanks,

Glenn Stauffer
--

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

Author: Glenn Stauffer
INET: stauffer_at_swarthmore.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------