RE: listener overloaded?

   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_at_earlham.edu> </div><div>Data:02/07/2014 21:01 (GMT-03:00) </div><div>Para: Jeff C <backseatdba_at_gmail.com>,oracle-l_at_freelists.org </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_at_freelists.org 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

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