Re: Can I tune 8i to login faster?

In article <38F325C5.43ED_at_yahoo.com>,
  connor_mcdonald_at_yahoo.com wrote:
> blebow_at_my-deja.com wrote:
> >
> > I am running Oracle 8i on win 2000. When starting up sqlplus on the
 same
> > machine, it takes a good 25-30 seconds to complete the login. The PC
 is
> > not overloaded, has plenty of memory, swap & disk space, etc. Nobody
> > else is using this oracle. Anything I can tweak to make startup
 faster?
> >
> > Thanks for any suggestions,
> >
> > -- Bill
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> That is not normal - it should be less than a second or so...
>
> Check your tnsnames.ora file and ensure that DNS lookups are not
 taking
> the time (possibly try just an IP address for the host setting and see
> what happens).
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
>

Thanks for taking the time to respond. I got it down to 15-20 seconds by disabling part of my virus protection program. Once connected in sqlplus, a new connect command gets executed very quickly. But the first connect takes 15 seconds or so.

I don't think I have a lookup problem as nslookup works quickly. I do think it has something to do with processes being spawned when I try the first connection. But that's only a guess.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 11 2000 - 00:00:00 CDT