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
