Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

I login sqlplus slowly?

SOLVED
Go to solution
Wangbin_1
Occasional Contributor

I login sqlplus slowly?

Hi,
I login sqlplus slowly After I input passward. The sqlplus version is shown very fast. but the "SQL>" prompt is display slowly(about 10 seconds). I want to find the reason. Can you help me?
5 REPLIES
harry d brown jr
Honored Contributor

Re: I login sqlplus slowly?

Probably DNS related.

please provide a lot more info if that answer doesn't cut it.

live free or die
harry
Live Free or Die
Wangbin_1
Occasional Contributor

Re: I login sqlplus slowly?

Hi,
the server is K380. and there are 2GB memory. the NIS is used to manage the username,password,hostname. and It work correctly. the sever don't use dns. the oracle version is 8.0.6.
T G Manikandan
Honored Contributor
Solution

Re: I login sqlplus slowly?

Do you have hostname in the listener.ora and the tnsnames.ora file(both server and the client).Change them to ip-address.
If the delay is due to the dns the above method will prove whether the delay is due to dns.

There could also be connections being very slow due to lack of resource.What is the usage of memory and swap on the machine.

I just got some info from oracle site which I have attached.Should be useful


Thanks
Tom Geudens
Honored Contributor

Re: I login sqlplus slowly?

Hi,
How does
tnsping
react ? Is it slow as well ? If so you're indeed having a resolving problem.

Regards,
Tom
A life ? Cool ! Where can I download one of those from ?
Wangbin_1
Occasional Contributor

Re: I login sqlplus slowly?

Thank you! Now I settle the problem!