Re: Oracle WAN performance questions

Roger and all others, thanks for the replies.

Roger,

We are using MTS, as the potential number of users connecting to this database is around 800. Is MTS slower than not using MTS ? I'm not sure about the dedicated or shared listeners but I can check on that. Does that have a performance impact as well ?
Also, what are the Net8 parameters that one can configure. Are they client side or server side ?

(I know thats a lot of questions, so you only have to answer the ones you want, and I can do some more research on the others)

Thanks.
Nick

"Roger Crowley" <rcrowley-enkidu_at_learningframework.com> wrote in message news:3D405F2F.30401_at_learningframework.com...
> Nick Palmer wrote:
> > 1) Why is the Oracle/SQL*Net/Net8 hitting us with 100ms latency, when
the
> > actual WAN latency is only 50ms? Can this be improved?
> >
> > 2) Should TNSPING always take more than double the PING time? If so, why
?
> > Nick.
> >
>
> Unfortunately, TNSPING is not a good measure of what your Net8
> communication is like. All TNSPING does is look up your command-line arg
> (the net8 db alias) in your tnsnames.ora file and then establish a
> handshake with the listener at the port specified. Note: 'ping' doesn't
> even do that much work (so is usually faster than tnsping).
>
> When your application contacts the listener, it goes thru the same thing
> as TNSPING, but then it does some additional steps (depending on how
> you've set up your Net8 architecture - eg, MTS, dedicated/shared
> dispatchers, etc): the listener spawns a dispatcher (if required) and
> the dispatcher then opens a network communication channel with the
> client (over a different port).
>
> If you have a firewall, this "different" port (between client and
> dispatcher) has to be recognized. Most firewall manufacturers know about
> the Net8 "hand-off" to a dispatcher, and allow for it (I've never done a
> timing study to see if this adds additional overhead).
>
> Do you use MTS? Dedicated or shared dispatchers? Have you tweaked any of
> the Net8 parameters (eg, buffers, etc)?
>
> Roger Crowley
>
Received on Fri Jul 26 2002 - 10:16:46 CDT