Re: Can I tune 8i to login faster?

If it's the first connection maybe the database is closed and he's starting everything, lgwr, arch, ckpt, smon, pmon, etc. Also, how large is your SGA? It takes us more than 15-20s to start up the database with a >1G SGA...

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) writes:

> On Wed, 12 Apr 2000 18:37:37 +0800, Connor McDonald
> <connor_mcdonald_at_yahoo.com> wrote:
>
> >
> >Still...something is very wrong with 15-20 seconds to spawn a process -
> >you could probably confirm if the spawning is the problem by using
> >pre-spawned processes - this is down by tweaking the sqlnet listener
> >files.
> >
>
>
> Too right! 15-20 seconds? Yuch!
>
> If he is connecting to the same node, he should be using the BEQ
> driver for the connection. That connects in 1-2 seconds, depending on
> speed of box. With TCP-IP, I've never been able to drop it from
> about 5 seconds, even with pre-spawned processes and direct IP
> addresses...
>
>
> Cheers
> Nuno Souto
> nsouto_at_nsw.bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
 

-- 
greg