HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
Command reference
Chapter 260
Command reference
ODBTK consists of two utilities:
• wlmoradc
• smooth
These utilities are described below.
wlmoradc
The wlmoradc tool is a data collector for HP-UX Workload Manager. It
provides 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.
Several items are needed for wlmoradc to function:
•Oracle home
• Instance name
• username/password
• SQL code
For more information on this utility, see wlmoradc(1M).
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).