Connecting to database takes 5 seconds

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:25:51 CDT