RE: listener overloaded?
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 2 Jul 2014 17:16:33 -0700
Message-ID: <1404346593.18129.YahooMailBasic_at_web181203.mail.ne1.yahoo.com>
Good suggestion there ... while there are no "silver bullets" most modern generic hardware can handle 10 connections a second easily. Better to have just a couple a second ... but ...
On Wed, 7/2/14, Jeremiah Wilton <jcwilton93_at_earlham.edu> wrote:
Date: Wed, 2 Jul 2014 17:16:33 -0700
Message-ID: <1404346593.18129.YahooMailBasic_at_web181203.mail.ne1.yahoo.com>
Good suggestion there ... while there are no "silver bullets" most modern generic hardware can handle 10 connections a second easily. Better to have just a couple a second ... but ...
Testing will probably show most systems can handle 100 connections a second but start to see implications ... hundreds ain't very good ... somewhere in that 10 to 100 ish range a second most people start thinking about connection pooling somewhere in the infrastructure.
Your mileage may vary ...
On Wed, 7/2/14, Jeremiah Wilton <jcwilton93_at_earlham.edu> wrote:
Subject: RE: listener overloaded?
To: "Jeff C" <backseatdba_at_gmail.com>, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Date: Wednesday, July 2, 2014, 8:01 PM
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 03 2014 - 02:16:33 CEST