30 meg is not a lot to have left. Try prespawning some listener
connections. See the network admin docs for that. It involves editing the
listener.ora file.
Jim
"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 - 08:41:26 CDT
