If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Usage of TDU and SDU in tnsnames.ora and listener.ora

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.

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.