Re: connection to the database is slow
- From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- To: <ikar@xxxxxxxxxxxxxxx>
- Date: Fri, 3 Feb 2006 17:27:46 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: