Peter, I've messed with TDU and SDU over the years with mixed and often unpredictable results. TCP.NODELAY has caused some very quirky problems with applications especially when mixed with large values for TDU/SDU. If you do set TDU/SDU set them equal to each other, doing otherwise has again produced some quirky and intermittent problems, like applications appearing to hang or timeout all together. What your trying to control is your server and client's use of the TCP/IP layer. Now if this particular application uses a local database, like our WorkManager CAD application, then these will have no effect since SQL*Net is basically not involved.
Dick Goulet ____________________Reply Separator____________________ Author: "Schauss; Peter" <[EMAIL PROTECTED]> Date: 10/11/2002 12:05 PM 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 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).