HP-UX Workload Manager User's Guide

Integration with other products
Integrating with Oracle® databases
Appendix D432
The next example is from
/opt/wlm/toolkits/oracle/config/user_cnt_boost.wlm. The second SLO,
Ora_1_slo, provides a minimum 20 share allocation. The first SLO,
Ora_1_slo_boost, becomes active and boosts the allocation to 40 shares if
the metric oracle.instance1.user_cnt is 11 or more.
slo Ora_1_slo_boost {
pri = 1;
cpushares = 40 total;
entity = PRM group Ora_grp_1;
condition = metric oracle.instance1.user_cnt > 10;
}
slo Ora_1_slo {
pri = 3;
cpushares = 20 total;
entity = PRM group Ora_grp_1;
}
Again, the tune structure shows wlmoradc providing the metric to WLM.
This tune structure also uses the smooth tool, which calculates a
running average of the last five user counts, smoothing out extreme
values when the user count is volatile.
tune oracle.instance1.user_cnt {
coll_argv =
wlmrcvdc
smooth -c 5
wlmoradc
--configfile /opt/wlm/toolkits/oracle/config/user_cnt.oradc
--home /oracle/app/oracle/product/8.1.5
--instance instance1
;
}