Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I tune 8i to login faster?

Re: Can I tune 8i to login faster?

From: <blebow_at_my-deja.com>
Date: 2000/04/11
Message-ID: <8d06tb$j73$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US