Re: Can I tune 8i to login faster?

blebow_at_my-deja.com wrote:
>
> 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.

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.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse