Re: connection to the database is slow

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Fri, 3 Feb 2006 17:27:46 +0100
Message-ID: <008801c628de$c8988f90$1a03310a@IBME1D11967173>

> It takes a long time to get connected to our Oracle 8i database.
> Once connection got established the performance is OK. However it may
> take few minutes to get connected.
> We are in dedicated mode. Any points how to investigate the problem?

I would check for DNS issues first: try to configure the tnsnames.ora/jdbc url etc with IP address instead of machine/logical host name.

If the problem is not there, check for lack of resources on the DB server(especially for available memory) and try to activate the OracleNet tracing.

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 03 2006 - 10:27:46 CST