HP-UX Workload Manager User's Guide

Integration with other products
Integrating with Oracle® databases
Appendix D 427
Why use Oracle database metrics with WLM?
The key benefit of using Oracle database metrics with WLM is that you
can use the database metrics to manage the performance of your
instances. You specify SLOs for the instances based on the metrics.
For example, with these metrics you can:
• Keep response times for your transactions below a given level by
setting response-time SLOs
• Increase an instance’s available CPU resources when a particular
user connects to the instance
• Increase an instance’s available CPU resources when more than n
users are connected
• Increase an instance’s available CPU resources when a particular job
is active
• Give an instance n CPU shares for each process in the instance
• Give an instance n CPU shares for each user connection to the
instance
For examples showing how to set up these types of SLOs, see the files
with names ending in “.wlm” in the directory
/opt/wlm/toolkits/oracle/config/.