Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g7K1bJb05202 for ; Mon, 19 Aug 2002 21:37:19 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id SAA13953; Mon, 19 Aug 2002 18:35:05 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 004B984E; Mon, 19 Aug 2002 18:08:20 -0800 Message-ID: Date: Mon, 19 Aug 2002 18:08:20 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Suhen Pather Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Suhen Pather Subject: how to reduce SQL*Net more data to client wait event Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C247E5.DB1E15A0" ------_=_NextPart_001_01C247E5.DB1E15A0 Content-Type: text/plain Hi, I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction of the CPU consumed by the system. I know this is not to be characterized as an idle wait event and can yield better performance if we increase the packet size. The database is Oracle 7.3.4 (SQL Net 2.3). What effect will increasing TDU and SDU have on this wait to increase packet size. It seems that if we can reduce this wait then we can save lots of time (I Think). Will using BEQ protocol help at all. Regards Suhen ------_=_NextPart_001_01C247E5.DB1E15A0 Content-Type: text/html

Hi,

I am tuning a system at a client site and notice lots of waits for SQL*Net more data to client (97%) for a fraction

of the CPU consumed by the system.

I know this is not to be characterized as an idle wait event and can yield better performance if we increase

the packet size.

The database is Oracle 7.3.4 (SQL Net 2.3). What effect will increasing TDU and SDU have

on this wait to increase packet size.

It seems that if we can reduce this wait then we can save lots of time (I Think).

Will using BEQ protocol help at all.

Regards

Suhen

------_=_NextPart_001_01C247E5.DB1E15A0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: Suhen.Pather@strandbags.com.au 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@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).