Jump to content United States-English
HP.com Home Products and Services Support and Drivers Solutions How to Buy
» Contact HP
More options
HP.com home
HP-UX Workload Manager Toolkits User's Guide: Version A.01.10.01 > Chapter 2 HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM

Command reference

» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

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).

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 it can be used with any stream of floating-point numbers.

For more information on this utility, see smooth(1M).

Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2001-2007 Hewlett-Packard Development Company, L.P.