Re: Wait event "SQL*Net more data to client" in wait class "Network"

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 27 Nov 2007 03:23:41 -0800 (PST)
Message-ID: <db40ca25-2c67-43b2-9e8a-6dc44f84e07d@s19g2000prg.googlegroups.com>

On Nov 24, 9:42 am, sybra..._at_hccnet.nl wrote:

> sql*net more data to client means your data doesn't fit in one sqlnet
> packet. The default packet size is 2k. You can adjust this by setting
> the SDU on listener and client tnsnames.ora.
> The SDU needs to be a multiple of the network card MTU, usually 1500
> bytes.

Last time I set those - three months ago - I was told by an "expert" that "those things don't matter anymore and it only shows my age" that I worry about them. Apparently new network gear and cabling doesn't suffer from MTU starvation...

Yeah! Right...
So I just changed them anyway,
see if I care?
;-) Received on Tue Nov 27 2007 - 05:23:41 CST