RE: listener overloaded?
- From: Rodrigo Mufalani <rodrigo@xxxxxxxxxxxxxxx>
- To: jcwilton93@xxxxxxxxxxx, Jeff C <backseatdba@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 02 Jul 2014 21:12:29 -0300
Jeff,
Check if listener.log file is bigger than 2gb. This is the major reason for
intermittent connections.
Also, check if your parameters processes and sessions are configured to
receive the load that you mencioned.
All the best,
Rodrigo Mufalani
Enviado por Samsung Mobile.
<div>-------- Mensagem original --------</div><div>De : Jeremiah Wilton
<jcwilton93@xxxxxxxxxxx> </div><div>Data:02/07/2014 21:01 (GMT-03:00)
</div><div>Para: Jeff C <backseatdba@xxxxxxxxx>,oracle-l@xxxxxxxxxxxxx
</div><div>Assunto: RE: listener overloaded? </div><div>
</div>Tail the listener log, and from another window do a 'lsnrctl status'.
Then see how long it takes to show up in the listener log.
Jeremiah
Sent from my Verizon Wireless 4G LTE smartphone
-------- Original message --------
From: Jeff C
Date:07/02/2014 10:18 AM (GMT-08:00)
To: oracle-l@xxxxxxxxxxxxx
Subject: listener overloaded?
How can I determine when my listener is overloaded/too busy? I am starting to
get intermittent tns ping alerts from EM, It is currently set to alert over
1000ms. Usually we are around 20ms. I haven't checked with the network guys
yet. I also have on average 400-500 connections per minute. I am not sure
what is considered too much
Jeff
Other related posts:
