Shrink the connection pool in a JDBC data source

In the Administration Console, you can manually shrink the pool of database connections in individual instances of a data source to the initial capacity or the current number of connections in use, whichever is greater.

To shrink the connection pool in a JDBC data source:

Navigate to the data source that you want to shrink:
- Navigate to JDBC data source system resources
- Navigate to JDBC application modules
Select the Control tab.
On the Control page, select the instances of the data source that you want to shrink.
Date source instances are listed by the server on which they are deployed.
Click the Shrink button.
Click Yes to confirm the action.
Results are displayed at the top of the page, and the Status of Last Action is changed to SUCCESS for each data source that you selected to shrink.