Re: Formula for number of DB Listeners on server

From: Ram <ram.cheruvattath_at_gmail.com>
Date: Tue, 13 Oct 2015 11:55:38 -0400
Message-Id: <EEAA9A7C-E6A7-4D97-91EF-BE93B80AAA51_at_gmail.com>

I am not sure I understand. Why would bouncing the listener affect existing connections?

Sent from my iPhone

> On Oct 13, 2015, at 10:58 AM, Woody McKay <woody.mckay_at_gmail.com> wrote:
>
> Hi,
>
> Is there a formula for figuring out how many DB Listeners there should be on a physical server?
>
> I'm part of a new team working on a new production setup for hosting. We currently have 40 SIDs per server with one listener. Occasionally, the listener appears to be unresponsive and the hosting team will bounce it breaking all connections for all SIDs on the box. So, the current configuration is not optimal.
>
> The hosting team is working with a vendor and is proposing a server with cpu, ram, storage that will handle upwards of 120+ SIDs. Obviously, each SID has a different workload and number of connections based on the size of the customer.
>
> Any thoughts or best practices for determining the number of DB listeners?
>
> Thanks for all wonderful sharing this group does.
>
> --
> Sincerely,
>
> WoodyMcKay

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

Received on Tue Oct 13 2015 - 17:55:38 CEST