Thursday, November 8, 2012

Shriking or Resetting a connection pool

http://docs.oracle.com/cd/E17904_01/apirefs.1111/e13952/pagehelp/JDBCjdbcdatasourcesjdbcdatasourcemonitorstatisticstitle.html

Active Connections Current Count: Active connections are connections in use by an application.

http://docs.oracle.com/cd/E13222_01/wls/docs92/jdbc_admin/manage.html#wp1048129


Force suspending a Data Source:
Suspends a data source that has the health state of Running, including disconnecting all current connection users. All current connections are closed and recreated.

Shrink:
Shrinks the database connection pool in the data source to either the current number of reserved connections or the initial size of the connection pool, which ever is greater.



No comments: