Re: Formula for number of DB Listeners on server

From: Tim Gorman <tim_at_evdbt.com>
Date: Tue, 13 Oct 2015 09:25:11 -0600
Message-ID: <561D2257.9050105_at_evdbt.com>

Q: Why isn't the hosting team and vendor proposing a VM cluster to run VMs on a template of one database instance and listener per VM instead?

1. Because then you wouldn't need as much hardware, and it would be too easy to manage, and it would be more highly available, all of which results in lower M2V (a.k.a. money to vendor) and M2H (a.k.a. money to host).

On 10/13/15 8:58, Woody McKay 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:25:11 CEST