What can be done to tune or at least improve the listener under certain
circumstances?
Listener Queue Size
. Allows a larger number of listener requests to
be serviced by allowing them to wait in a queue. This will help an
OLTP database, but it is unlikely to help a data warehouse. Data
warehouses require a minimal number of concurrent connections but
large amounts of throughput. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.