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@xxxxxxxxx> 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
