HP-UX Workload Manager User's Guide

Integration with other products
Integrating with Oracle® databases
Appendix D428
Tools in the HP-UX WLM Oracle Database Toolkit
(ODBTK)
This toolkit includes two tools:
wlmoradc
wlmoradc is a data collector for Workload Manager and
is designed to provide an easy building block for Oracle
instance management with wlmd.
It takes one or more SQL statements and uses the
Oracle tool SQL*Plus to connect to an Oracle instance
and execute the statements, returning either the raw
value returned from the SQL or the elapsed execution
time. The results are sent to stdout for human viewing,
logging, or most often, for use by wlmd by means of the
wlmrcvdc or wlmsend utilities.
smooth
smooth takes a stream of newline-delimited numbers
and outputs a stream of numbers that are a running
average of the last n values, where n is a value that can
be set on the command line. The principal use for the
smooth utility is to remove short spikes or dips in data
collector output used with WLM, but can be applied to
any stream of floating-point numbers.
Although not part of ODBTK, the functionality provided by the
cpushares keyword in the WLM configuration file fits quite nicely with
the toolkit.
NOTE The cpushares keyword is available starting with WLM
Version A.01.02.
A CPU share is a portion of the CPU resources. The cpushares keyword
allows shares-per-metric allocations. This enables you to create
goal-based SLOs in WLM of the form “x percent of the CPU resources for
each metric y,” such as three CPU shares for each process in a workload.
(This type of allocation can also be thought of as a parametric allocation.
It is calculated directly from the metric and is thus a function of the
metric. This type of function is a parametric equation.)