HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
Tools in WLM Oracle Database Toolkit (ODBTK)
Chapter 2 25
Tools in WLM Oracle Database Toolkit
(ODBTK)
This toolkit includes two tools:
wlmoradc
The wlmoradc tool is a data collector for HP-UX
Workload Manager and is designed to provide an easy
building block for Oracle instance management with
wlmd(1M).
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(1M) by means
of the wlmrcvdc(1M) or wlmsend(1M) utilities.
smooth
NOTE As of WLM A.02.02, HP recommends that you use the
cntl_smooth WLM keyword instead of the smooth tool.
For information on cntl_smooth, see wlmconf(4).
The smooth tool 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.