Question:

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?

Answer 1:

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).