I have configured a datasource and assigned maximum capacity of 10 and initial capacity to 2 and targeted it to all server in a clusters(node 1 & node 2).
now how the connections will be utilized in the clustered mode. Both the node will have maximum of 10 connection limit
or each node will have maximum of 10 connection limit ? please clarify me.
Maximum capacity is number of allocated session in database side for WebLogic Server divide by number of WebLogic server. Example, DBA allocated 500 session for WebLogic server which has 5 server, so this config value is 500/5 = 100
Initial capacity mean number of initial session created when data source started. Recommended value for Initial Capacity is equal to Maximum Capacity size database connection pools. In this case WebLogic never increase the number of connections when it needed by application. Negative impact for this case is increase DB load although only few session use by WebLogic, but if impact in database side is not significant its work well.