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. |
Metric & Service | Command line example |
---|---|
Switch User Percentage | java -jar application-monitoring-metrics-cli.jar mws -host=localhost -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=plsql_switch_user_percentage -wa=10 |
Waited Requests Percentage | java -jar application-monitoring-metrics-cli.jar mws -host=localhost -port=<Managed Server JMX Port> -user=ifsmon -pass=<password> -request=plsql_waited_requests_percentage -wa=15 |