Re: Troubleshooting slow logins

You did not say what steps you have tried, so it is not easy for us to guess what might help to speed up the "login".

1. Have you tried to tnsping the db? If it is slow, it would be your network problem.
2. have you tried to replace your hostname in your tnsnames.ora file and use IP address directly, to see if it improves?

Just a couple of ideas.

Hope it helps.

Guang

In article <39E36B24.FD9E96C_at_Unforgetable.com>,   BlueSax_at_Unforgetable.com wrote:
> I'm trying to help someone troubleshoot slow logins to an 8i database
 on
> an NT server.
>
> I started off by researching the subject on Oracle's MetaLink site and
> came across all of the information about college.dat and regid.dat,
> tracing, etc. etc. After performing all of the checks that those
> articles mentioned, the logins are still slow.
>
> Does anyone here have any suggestions as to where I might want to look
> next? I do know that there is some general tuning that should be done
 on
> this database, but as it is right now anything which is executed after
> the login seems to work pretty rapidly - it is just the login that is
> slow at this point.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 10 2000 - 16:19:26 CDT