Skip to Main Content
  • Questions
  • Application vs Middle Tier Connection Pooling

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Keith.

Asked: July 20, 2018 - 10:48 pm UTC

Last updated: July 24, 2018 - 10:47 am UTC

Version: 12.1

Viewed 1000+ times

You Asked

Do you have a recommendation for use of connection pooling in the application vs a middle tier pool? Would you suggest WLS to manage a conn pool at the middle tier? any issue for .net or python applications to access the pool for connections?

and Connor said...

For me, what really matters is making sure you have good *management* of the pool, wherever it is. I worked at a place where the middle tier was implemented with Windows services, each of which ran their own connection pool.

The developer *intent* was good, ie, use a pool with a small size of connections, but from a *database* perspective we ended up seeing 500 services x 8 connections in each pool and lo and behold, we've got 4000 sessions on the database, most of which were probably not required.

Something like DRCP

https://www.oracle.com/technetwork/articles/oracledrcp11g-1-133381.pdf

might have been a better option in that case.

So the "where" is not as important as being able to appropriately control and configure the connection pool

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Keith Marshall, July 24, 2018 - 5:48 pm UTC

Thank you for your feedback. Very quick response and i believe to be good accurate advice. Only thing now if to see if DRCP actually works in the customer environment and ecosystem. Thanks much!!

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database