Re: listener overloaded?

From: Jeff C <backseatdba_at_gmail.com>
Date: Wed, 2 Jul 2014 17:50:19 -0700
Message-ID: <CAKsxbLrjQpDDkGKEpUWmOpTWWf_exyKCVUR6yXMpsbn8F+6X_w_at_mail.gmail.com>

Well I actually have neglected to check my listener.log file in a while and it was at 1.9gb. I am usually routinely check that but have forgot lately.. So I trimmed it and see if that helps.
Thanks.

On Wed, Jul 2, 2014 at 5:12 PM, Rodrigo Mufalani <rodrigo_at_mufalani.com.br> wrote:

> 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.
>
>
> -------- Mensagem original --------
> De : Jeremiah Wilton
> Data:02/07/2014 21:01 (GMT-03:00)
> Para: Jeff C ,oracle-l_at_freelists.org
> Assunto: RE: listener overloaded?
>
> 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

Received on Thu Jul 03 2014 - 02:50:19 CEST