Skip to Main Content

#SmartDB Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours.

Header container

May 22, 2019

Sizing Connection Pools: Concepts
Main topic of this session: the concepts that drive the sizing of a connection pool.
- Connection reservation
- Connection queueing
- CPU oversubscription
- Database oversubscription
- %Idle Time inside database foreground sessions

Subscribe to give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Sizing Connection Pools: Concepts you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

Your Expert
ToonKoppelaars
ToonKoppelaars, Consulting Member of Technical Staff    
Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real-World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modeling (see his idea on SQL Assertions here https://community.oracle.com/ideas/13028). He is a long-time champion of the Smart Database paradigm, i.e. using the database as a processing engine, and not just as a persistence layer.