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. |