Database Reference
In-Depth Information
3.
Click on the
Monitoring
tab. Here, the state of the data sources (for ex-
ample, running), as well as the average, current, and high active connections
count are displayed.
4.
Click on
Customize this table
. From
Column Display Available
, select
Current Capacity, Leaked Connection Count, Number Available
, and
Active Connections Current Count
, and move them under
Chosen
Column
.
5.
Click on
Apply
.
6.
The
Monitoring
tab of the data source will look like that shown in the follow-
ing screenshot. The key is to ensure that the sum of
Active Connections
Current Count
and
Leaked Connection Count
do not exceed the connec-
tion pools'
Current Capacity
. If they do, it is either time to fix the leaked con-
nections or increase the pool capacity.
7.
To get the maximum capacity to determine how to appropriately size your
connection pool:
•
Click on the data source name (for example,
SOADataSource)
.
•
Navigate to
Configuration
|
Connection Pool
.
•
Note the setting of the
Maximum Capacity
parameter.
In cases where the database may not be accessible or is down, the database
password used for the connection pool has expired or reset, network related is-
sues occur, or data source related errors begin to appear in the logs, it may be