Oracle-L: RE: Has anyone experiemented with SQLPLUS connection times ?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 19 May 2003 10:31:52 -0800
Message-ID: <F001.0059CC52.20030519103152@fatcity.com>

Michael

Yes, just set the RUN_FASTER=TRUE parameter in sqlnet.ora. Just kidding. My experience has been that the networking side tends to be set up pretty good out of the box. However, your situation may run into problems in one of the following areas:

1. Excessive trips between the client and server.
2. Big packets.
3. Scalability.

Do you think any of those are your problem?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Monday, May 19, 2003 11:52 AM
To: Multiple recipients of list ORACLE-L

List,

Anyone on the list done any experiments by adjusting O/S, init.ora or network parameter files to show how SQLPLUS connections either locally or over the network can speed up or slow down. If so, could you please direct me as needed.

Thank You in advance.

Mike

--

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

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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 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). Received on Mon May 19 2003 - 13:31:52 CDT