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 2 57
Step 8. Activate the WLM configuration file:
# wlmd -a configfile
Specifying a desired metric level (goal-based)
Rather than worrying about the amount of CPU resources an instance
gets per metric, you can specify a desired goal for the metric. Using a
goal statement in the WLM configuration, you indicate the current
value of the metric (obtained from wlmoradc) and your desired goal for
the metric. The following example, from
/opt/wlm/toolkits/oracle/config/timed_select_scott.wlm, shows a goal
statement, with the goal for the metric value to be less than 2.5:
slo Ora_1_slo {
pri = 1;
mincpu = 20;
maxcpu = 80;
entity = PRM group Ora_grp_1;
goal = metric oracle.instance1.sel_scott_resptime < 2.5;
}
The metric in the goal statement,
oracle.instance1.sel_scott_resptime, is kept current by using
wlmoradc in its tune structure, in the same configuration file:
tune oracle.instance1.sel_scott_resptime {
coll_argv =
wlmrcvdc
wlmoradc
--configfile
/opt/wlm/toolkits/oracle/config/select_scott_resptime.oradc
--home /oracle/app/oracle/product/8.1.5
--instance instance1
;
cntl_kp=3;
}
HP-UX WLM then automatically adjusts the CPU resources for the
instance’s associated workload group, in an attempt to meet the goal
value. Generally speaking, the goal could be time-driven or a threshold
for the number of transactions, or any number of other types of goals.