From: gmei@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: Troubleshooting slow logins
Date: Tue, 10 Oct 2000 21:19:26 GMT
Organization: Deja.com - Before you buy.
Lines: 38
Message-ID: <8s014m$q7t$1@nnrp1.deja.com>
References: <39E36B24.FD9E96C@Unforgetable.com>
NNTP-Posting-Host: 64.69.114.190
To: BlueSax@Unforgetable.com
X-Article-Creation-Date: Tue Oct 10 21:19:26 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x55.deja.com:80 (Squid/1.1.22) for client 64.69.114.190
X-MyDeja-Info: XMYDJUIDgmei


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@Unforgetable.com>,
  BlueSax@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.