|
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
|
- Re: how to reduce SQL*Net more data to client wait e... Suhen Pather
- Re: how to reduce SQL*Net more data to client w... Jakob Hammer-Jakobsen
- Re: how to reduce SQL*Net more data to client w... Anjo Kolk
- RE: how to reduce SQL*Net more data to client w... John Kanagaraj
- Re: how to reduce SQL*Net more data to client w... Anjo Kolk
- Re:RE: how to reduce SQL*Net more data to clien... dgoulet
- Re: how to reduce SQL*Net more data to client w... Tim Gorman
- Re: how to reduce SQL*Net more data to client w... Suhen Pather
- RE: how to reduce SQL*Net more data to client w... Johnson, Michael
- Re: how to reduce SQL*Net more data to client w... Anjo Kolk
- RE: how to reduce SQL*Net more data to client w... Johnson, Michael
