Re: Tuning sql*net

Kalle wrote:

> Hi,
>
> we have an environment where between application server and database
> server is a firewall and also they are situated in different physical
> location...
>
> is there anything to do in order to improve sql*net traffic in case of
> heavy queries...
>
> rgds and tia
> Kalle
>

There is rarely a situation where it is needed, but the SQL*Net guides are your friends.
I've seen some improvements in switched networks, fiddling SDU.
More improvements are to be expected from tuning design and statements, as mentioned by others.

-- 

Regards,
Frank van Bortel