Usage of TDU and SDU in tnsnames.ora and listener.ora
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 220.127.116.11.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).
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
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
SQL*Net wait events are pretty much idle events. Most times they can be ignored.
However, If you are pumping ALOT of data, tweaking the SDU/TDU parameters may help. The change is relatively transparent; change the tnsnames.ora on the client, change the listener.ora on the server and reload the listener.
I have experimented with SDU/TDU in my environment, but have not experienced a noticable improvement.