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 244
# Determine the number of number of connected users for instance1 and
# pass the metric on to wlmd.
#
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
;
}
#
# Determine the number of number of connected users for instance2 and
# pass the metric on to wlmd.
#
tune oracle.instance2.user_cnt {
coll_argv =
wlmrcvdc
wlmoradc
--configfile /opt/wlm/toolkits/oracle/config/user_cnt.oradc
--home /oracle/app/oracle/product/8.1.5
--instance instance2
;
}
Next, we present the previous example modified. The modified file,
/opt/wlm/toolkits/oracle/config/alpha_shares_per_user.wlm, has been
altered as follows:
• There are three managed instances: alpha, beta, and gamma. Each
instance gets a workload group: alpha_grp, beta_grp, and
gamma_grp.
• There are three less important instances that are not actively
managed: larry, moe, and curly. These instances share the
static_instances workload group.
• $ORACLE_HOME for these instances does not match the $ORACLE_HOME
in the previous example file. As a result, the application record lines
in the modified file were changed.
• Because there are more instances, the minimum allocations were
changed slightly.
• Because there is no batch work done on the machine, the
long_batch workload group was removed.