Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connecting to database takes 5 seconds
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.
hth
Sk
"Wolfram Roesler" <wr_at_grp.de> wrote in message
news:Xns92559D7FA2564wrgrpde_at_62.153.159.134...
> Hello,
>
> we have:
>
> * an Oracle 8i server: 900 MHz, 256 MB RAM, Windows 2000
> * a workstation: 1600 MHz, 640 MB RAM, Windows XP, Oracle 9i client
> software
>
> It takes five to eight seconds to connect to the database from the
> workstation! All init.ora parameters are set to LARGE or larger,
> the server still has some 30 MB RAM free, and there's plenty of LAN
> bandwidth left. Does anybody know how the DB connection can be speeded
> up?
>
> The delay takes places both when starting sqplus (via Start -> Execute)
> and when connecting to the database via ODBC. We are using the 9.0.1.4
> version of the 9i ODBC driver.
>
> Thanks for any help
> W. Roesler
Received on Wed Jul 24 2002 - 11:11:40 CDT