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 39
Commands specified only in the WLM configuration file
Specifying commands in the WLM configuration file is ideal for a DBA
who also serves as a system administrator, as this method requires root
privileges. With root privileges, the system administrator can
conveniently edit the configuration file to collect the necessary metrics.
In addition, this method requires the configuration file to be activated
(with wlmd -a), which can only be done by a system administrator.
With this method, wlmoradc is specified in the HP-UX WLM
configuration file in a coll_argv line. Consider the following example
from the /opt/wlm/toolkits/oracle/config/shares_per_user.wlm file:
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
;
}
Here, the system administrator sets the version of Oracle to use and the
instance to monitor. Any environment variables required by Oracle are
set in the WLM configuration file. The administrator also chooses the
metric to collect by using the wlmoradc configuration file user_cnt.oradc.
For more examples, see the files ending in “.wlm” in the
/opt/wlm/toolkits/oracle/config/ directory.
Commands external to the WLM configuration file
For environments with separate people in the system administrator and
DBA roles, it is possible to have the system administrator set up the
WLM configuration file with the data collector commands outside the
file. This allows the DBA to easily change the metrics being collected
without having to alter the configuration file. To accomplish this, the
administrator sets up a coll_argv line to monitor a given metric using
wlmrcvdc.