HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
How do I use the metrics?
Chapter 236
Step 2. Customize the appropriate WLM configuration file.
a. Determine whether metrics will be collected internal or external to
the configuration file. To decide this issue, see the section
“Implementing metrics as a system administrator vs. as a DBA” on
page 38.
b. Copy the WLM configuration files from the directory
/opt/wlm/toolkits/oracle/config/ to the local directory. These files have
a “.wlm” extension. In these files, you define SLOs, the metrics you
want to track, and how to track them.
c. Identify which instances will be managed.
d. Customize the instance names and paths in the configuration file to
your environment.
e. Create a workload group for each instance in the prm structure in the
configuration file.
f. Create or modify the SLOs to better fit your goals. SLOs are specified
in slo structures.
NOTE If the system is going to have interactive users, you may want to
reserve a portion of the CPU resources to ensure reasonable response
times for these users. You can reserve CPU resources by adding an
SLO similar to the following in your configuration file:
slo keep_interactive_nice {
pri = 1;
cpushares = 10 total;
entity = PRM group OTHERS;
}
This SLO reserves 10% of the system CPU resources for interactive
users.
NOTE For optimal performance, do not set the wlm_interval keyword in
your WLM configuration to a value of less than 10 seconds when
using the wlmoradc data collector.