Re: connection pool sizing
From: Martijn Bos <maboc_at_maboc.nl>
Date: Mon, 14 Sep 2015 23:47:59 +0200
Message-ID: <55F7408F.4070700_at_maboc.nl>
I think it more depends on the usage of the connections in the pool. If all your connections, out of the pool, are always busy it is probably wise to take numbers of CPU into account. If they are only used once in a while I would monitor connectionpool usage.
Date: Mon, 14 Sep 2015 23:47:59 +0200
Message-ID: <55F7408F.4070700_at_maboc.nl>
I think it more depends on the usage of the connections in the pool. If all your connections, out of the pool, are always busy it is probably wise to take numbers of CPU into account. If they are only used once in a while I would monitor connectionpool usage.
Best Regards,
Martijn
On 14-09-15 20:57, Stephens, Chris wrote:
> Are there general recommendations on initial connection pool sizing based on the number of CPU's available to a database?
>
> I keep seeing connection pools sized far (far!) beyond the number of CPU's and that doesn't make any sense to me.
>
> Chris
>
>
>
> Confidentiality Notice:
> This message may contain confidential or privileged information, or information that is otherwise exempt from disclosure. If you are not the intended recipient, you should promptly delete it and should not disclose, copy or distribute it to others.
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Sep 14 2015 - 23:47:59 CEST