100. Middle Tier - PL/SQL Connection Pool¶
The PL/SQL Connection Pool is a limited resource. If many requests need to wait or if the number of switched users is high it might impact the system responsiveness.
Multiple Instances: Yes (per ManagedServer)
Interval: Every 5 minutes (288 times per day)
| Status | Expression |
|---|---|
| Warning | If (( Switch User Percentage > 10%) or ( Waited Requests Percentage > 15%)) |
| OK | If not status Warning. |
| Unknown | Missing application response. |