Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Do multiple Connection Pools need to have the same number of connection?
Jerry S.
Rank 4 - Community Specialist
We have created additional connection pools in some of our data bases in order to handle init blocks, variables, etc.
My question is, do the additional connection pools for any physical database need to have the same number for "Maximum Connections" as the original connection pool?
So if the Maximum Connections for my original connection pool is 10, can I set the Maximum Connections for my init block connection pool to 5?
Will this cause any issues?
0
Answers
-
They are independent.
Size each connection pool based on (a) the estimated workload it will deal with and then (b) the actual workload based on DMS statistics to determine the high watermark of connections busy at one time per connection pool.
0 -
Thank you for the information.
0