Oracle-L: Session Data Unit and tcp.nodelay

From: Schauss, Peter <SCHAUPE_at_mail.northgrum.com>
Date: Fri, 11 Oct 2002 12:05:11 -0800
Message-ID: <F001.004E7333.20021011120511@fatcity.com>

We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements.

The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together.

Does anyone have any experience with these settings?

Any suggestions as to what settings to try as a start?

Thanks,
Peter Schauss
Northrop Grumman Corporation
schaupe_at_mail.northgrum.com
--

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

Author: Schauss, Peter
INET: SCHAUPE_at_mail.northgrum.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 Fri Oct 11 2002 - 15:05:11 CDT