RE: Wait event problems

Here is an old paper from an Oracle analyst discussing SDU/TDU settings... http://www.fors.com/eoug97/papers/0285.htm.

I never came across any upgraded version of the same.

• Kirti

-----Original Message-----
Sent: Friday, June 14, 2002 2:01 PM
To: Multiple recipients of list ORACLE-L

Hello,

There are many theoretical things about tuning SDU/TDU. But, I don't think tuning SDU/TDU makes benefit in practice.

Kathy Duret wrote:

> FWIW
>
> I tried "mucking" around with the SDU/TDU parameters on both the client
and the server and never got much success. Tried to up the 2K to 8K but it still was sending alot of 2k packets. I had more results upping the array size to 90-100 in glogin (default is 15).
>
> Kathy
>
> -----Original Message-----
> Sent: Thursday, June 13, 2002 6:53 PM
> To: Multiple recipients of list ORACLE-L
>
> This is never an "idle" event. The phrase "more data from client"
indicates
> that the individual SQL operation is larger than a single SQL*Net packet.
> No big deal; it happens all the time, and SQL*Net handles it with
> "continuation packets". Only issue is that the client is taking a lot of
> time between each packet sent. Jack's conclusion that the client process
> (in the "client-server" database connection) is not providing data in a
> "timely fashion" is exactly correct. You most likely have a slow client
> process...
>
> Oracle documentation frequently tries to encourage mucking about with
> SDU/TDU parameters in SQL*Net configuration files, but I've rarely seen
this
> be more effective than tuning the client process... :-)
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

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