Re: Net8 Performance Tuning (client/server tuning)

Im not sure about the detail of what you ask although I do know that a tnsping will do far less than a real connection. TNSPing only has to make a network connect be rsolved to a database by a listener and do a nominal logon. A true connect does all of these things and also sets up and reserves system resources for a full oracle user session that could go on to fire massive queries at the database and need large chunks of Operating System memory for it to do its work.

At least that is my understanding.
So no surprises is the timing difference.

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United Kingdom)

                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <bahung33_at_hotmail.com> wrote in message news:82mg1k$okq$1_at_nnrp1.deja.com...
> I am trying to accomplish two objectives. One, I want to
> speed up the connection time from the client to the server.
> It takes about 220
> milliseconds for TNSPing to return a response. However it
> takes five or six seconds to connect to the database via
> SQL*Plus. Second, I want to do general network (Net8) performance
> tuning.
>
> What can I do to improve the connection time? What
> strategy delivers the biggest bang for the bucks?
>
> Would you explain the differences between 'client load
> balancing' and 'connection load balancing' and how to
> implement both?
>
> Lastly, how do you determine the number of possible
> connections per process for the particular operating
> system? I'm trying to determine the initial number of dispatchers
> to start.
>
> Thanks,
>
> Hung
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 09 1999 - 08:49:38 CST