Do multiple Connection Pools need to have the same number of connection?

Question

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?

Jerry S. · Answer

Thank you for the information.

rmoff · Answer

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.