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 240
For example, from
/opt/wlm/toolkits/oracle/config/manual_payroll_boost.wlm, the metric
oracle.instance1.payroll_running is monitored because of the following
tune structure:
tune oracle.instance1.payroll_running {
coll_argv = wlmrcvdc ;
}
This structure sets up a mechanism using wlmrcvdc that takes metric
values and feeds them into HP-UX WLM. These values are provided by
the DBA using wlmsend in one of the manners described below. For
information on these utilities, see wlmrcvdc(1M) and wlmsend(1M).
The DBA provides metric values to wlmrcvdc in one of the following
manners:
• Once, with a hard-coded value:
Using wlmsend, send the value 1 to WLM to indicate the payroll
application is running:
# wlmsend oracle.instance1.payroll_running 1
Similarly, use wlmsend to send the value 0 to indicate the payroll
application is not running:
# wlmsend oracle.instance1.payroll_running 0
• Continuous, with values from wlmoradc:
Here, wlmoradc uses a configuration file and reports values every 60
seconds. These values are piped to wlmsend, which in turn, feeds the
values to WLM:
# wlmoradc --configfile file --interval 60 | wlmsend \
oracle.instance1.payroll_running &
• Once, with a value from wlmoradc:
Here, wlmoradc uses a configuration file again, but reports a value
only once:
# wlmsend oracle.instance1.payroll_running \
`wlmoradc --configfile file --single`