Re: Connecting to database takes 5 seconds

From: Wolfram Roesler <wr_at_grp.de>
Date: Thu, 25 Jul 2002 10:16:53 +0200
Message-ID: <Xns9256691E96468wrgrpde@62.153.159.134>

Hi,

"SK" <no-one_at_yahoo.com> wrote in news:ahmjjs$u495m$1_at_ID- 84096.news.dfncis.de:

> It could be your workstation not able to resolve dbserver hostname
> efficiently. Try to use ip address on client or use sqlplus on dbserver
> itself to know exact cause.

I changed the hostname into the server's IP address using "Net Manager" on the client PC, but to no avail, even after a reboot. "ping servername" on the client responds without any relay, so name resolution seems to work fine anyway.

Connecting with "sqlplus user/password" on the server itself takes about two seconds, compared to seven on the client. It's a very small network with less than 20 machines in it, and a very small database with less than 10 concurrent sessions.

Thanks for your help
W. Roesler Received on Thu Jul 25 2002 - 03:16:53 CDT