Re: Troubleshooting slow logins

Hi,

I had a problem with slow login's to an 8i database. It turned out to be a lack or memory on the server, (or too large an SGA for the memory available)

Have you checked this ?

Cheers

NeilC

gmei_at_my-deja.com wrote in message <8s014m$q7t$1_at_nnrp1.deja.com>...
>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 Wed Oct 11 2000 - 03:11:44 CDT