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 55
b. Invoke wlmoradc.
In the tune structure below, wlmoradc uses the times.oradc file to
track the time for the transaction for the instance named instance1.
The result is forwarded to HP-UX WLM by wlmrcvdc.
tune O1_transaction01_time {
coll_argv = wlmrcvdc
wlmoradc
--configfile times.oradc
--instance instance1
;
}
Step 6. Check the WLM configuration file’s syntax:
# wlmd -c configfile
Fix any errors that are found.
Step 7. Activate the WLM configuration file:
# wlmd -a configfile
Specifying an amount of CPU resources per metric
(parametric)
You can specify an SLO for an instance’s workload group that requests
an allocation that varies in direct proportion to a given metric. Such an
SLO must make use of the cpushares keyword in the WLM
configuration file. Given a metric, cpushares determines how many
CPU shares that each unit of the metric is currently allocated. You then
create a goal to maintain a shares-per-metric level that provides the
desired performance.
To implement this type of SLO:
Step 1. Identify what database condition is interesting, for example: number of
users, number of processes, and so forth.
Step 2. Identify the SQL statements that capture that information.
Step 3. Confirm the SQL statements using SQL*Plus by hand.
Step 4. Place the working SQL in an wlmoradc configuration file (copy the file
/opt/wlm/toolkits/oracle/config/user_cnt.oradc to a local filename, say
my_user_cnt.oradc, and change the SQL section).