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 256
Step 5. Invoke wlmoradc on the command line:
# wlmoradc --configfile my_user_cnt.oradc
If there are problems, add the option --debug 2 to see the SQL input
and output and determine the causes:
# wlmoradc --configfile my_user_cnt.oradc --debug 2
Step 6. In your WLM configuration file:
a. Specify your SLO, as shown in this shares-per-process example. Here,
the goal is for each process to have at least three CPU shares:
slo Ora_1_slo {
pri = 1;
mincpu = 5;
maxcpu = 90;
entity = PRM group Ora_grp_1;
cpushares = 3 total per metric oracle.instance1.proc_cnt;
}
b. Invoke wlmoradc.
In the tune structure below, wlmoradc uses the process_cnt.oradc file
to determine the number of processes for the instance named
instance1. The number of processes is then forwarded to WLM by
wlmrcvdc. HP-UX WLM uses cpushares to divide the number of
CPU shares for workload group ora_grp_1 by the number of
processes.
tune oracle.instance1.proc_cnt {
coll_argv =
wlmrcvdc
wlmoradc
--configfile
/opt/wlm/toolkits/oracle/config/process_cnt.oradc
--home /oracle/app/oracle/product/8.1.5
--instance instance1
--interval 30
;
}
Step 7. Check the WLM configuration file’s syntax:
# wlmd -c configfile
Fix any errors that are found.