Usage of TDU and SDU in tnsnames.ora and listener.ora
Hello,
I'm experiencing many wait events on "SQL*Net message to client" (26720802) and "SQL*Net message from client" (26720868).
The db is a Oracle 8.1.7.1.1.
The db is used by a forms application that runs on a different node (IAS).
I read in the manual that this could be resolved by tuning the TDU- and SDU-parameters in the TNSNAMENS.ORA and LISTENER.ORA.
I know how to do this, but because this is a production db, I want some reassurance (if possible).
My questions:
1. Does anyone have any experience using these parameters? Are there any pitfalls?
2. Does it really make a huge difference?
3. Is there a way to test if the parameters are actually working? (The number of wait events will decrease maybe, but I want to check and double-check the alteration.)
Thanks in advance and excuses for any typos
Erik
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.