HP-UX Workload Manager User's Guide

Integration with other products
Integrating with Oracle® databases
Appendix D 431
ODBTK examples
As noted in the previous section, ODBTK comes with many useful
examples in the directory /opt/wlm/toolkits/oracle/config/. We will look at
parts of those files here.
The first example draws from
/opt/wlm/toolkits/oracle/config/shares_per_user.wlm. The slo structure
gives workload group Ora_grp_1 three CPU shares for each user
connected to the associated Oracle instance.
slo Ora_1_slo {
pri = 1;
mincpu = 5;
maxcpu = 90;
entity = PRM group Ora_grp_1;
cpushares = 3 total per metric oracle.instance1.user_cnt;
}
Looking at the tune structure in the same file, we see that the metric
oracle.instance1.user_cnt is provided by wlmoradc, which uses the SQL
in the configuration file user_cnt.oradc to get the user count.
tune oracle.instance1.user_cnt {
coll_argv =
wlmrcvdc
wlmoradc
--configfile /opt/wlm/toolkits/oracle/config/user_cnt.oradc
--home /oracle/app/oracle/product/8.1.5
--instance instance1
;
}