Re: Connecting to database takes 5 seconds

How are you resolving the database service name to an address? Tnsnames.ora, oracle names, hostname, ldap?

After connecting to the database, compare the timestamps in the listener.log file and the v$session table for your connection? Is there a difference in times? If so the problem is probably the server launching a server thread. If not it is probably a network induced delay.

Ping the server using the same hostname as Net8 is using. Is there a noticable delay? Try it both by host name and IP address. This may tell you where the problem lies. If IP address comes back faster then there is a problem with host name lookup.

Try the same from the server back to the client? The problem could be on either end of the connection.

Let us know how you make out.

--
Chuck


"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