Re: connection pool sizing
Date: Tue, 15 Sep 2015 00:25:11 +0200
Message-ID: <CAF+iMcHFdN15SDaX-74Qt4AiKcXO35T1j2mkEDG5+MigA_G5wA_at_mail.gmail.com>
This is a topic covered by the Real World Performance Group; no one does it better explaining this. Here is one link to a recent preso I found by googling:
http://rwpt.hroug.hr/content/download/6547/107877/file/RWP2015%20part%20I.pdf
If you go to Open World, be sure to catch at least one of their sessions, it is probably the best infotainment you get there, especially if you have a taste for British sarcasm ;-) Also get in touch with your local user group and see if they have invited them for 2016.
2015-09-14 23:47 GMT+02:00 Martijn Bos <maboc_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.
> >
> >
> >
>
>
-- Øyvind Isene +47 90864882 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 15 2015 - 00:25:11 CEST