RE: connection to the database is slow
- From: "Kline.Michael" <Michael.Kline@xxxxxxxxxxxx>
- To: <cichomitiko@xxxxxxxxx>, <ikar@xxxxxxxxxxxxxxx>
- Date: Fri, 3 Feb 2006 11:57:52 -0500
I remember a long time ago some stories if your listener.log was
excessively large you could have a problem like this.
Another maybe.
Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Radoulov, Dimitre
Sent: Friday, February 03, 2006 11:28 AM
To: ikar@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//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]
--
//www.freelists.org/webpage/oracle-l
Other related posts:
