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%))

Impact Increased latency. The users notices slow responsive system.
Suggestion The Max Pool Size on PLSQL Connection Pool may have to be increased. Look for more information in IFS System Monitoring.
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