RE: connection to the database is slow

Try connecting on the same box as the database thru' tnsnames.ora (tcp) connection. If it is still slow it is a listener issue.    

  Check if listener is one of the top processes. The listener may be having a lot of workload, in which case listener process can be assigned a higher priority or a second listener can be created (but on a different port - and this may not be preferred).    

  Load on the listener can be reduced by turning the local database connections to "bequeath" instead of ipc or tcp.    

  Regards    

  Joseph Amalraj          

  -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre Sent: Friday, February 03, 2006 11:28 AM To: ikar_at_med.cornell.edu
Cc: oracle-l_at_freelists.org
Subject: Re: connection to the database is slow

> 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 



LEGAL DISCLAIMER 
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer. 

Seeing Beyond Money is a service mark of SunTrust Banks, Inc. 
[ST:XCL] 




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



  


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