How Do CPU Cores Service More Than One Session at a Time When Using UCP? (Doc ID 3037432.1)

Last updated on JULY 26, 2024

Applies to:

Goal

The Universal Connection Pool (UCP) Developer's Guide contains a chapter on real-world performance:
https://docs.oracle.com/en/database/oracle/oracle-database/23/jjucp/optimizing-real-world-performance.html

That chapter states that "the number of connections to the database system must be based on the CPU cores available on the system. Oracle recommends 1-10 connections per CPU core."

How can one CPU service more than one session at a time?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.