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

Tools in WLM Oracle Database Toolkit (ODBTK)

» 

Technical documentation

Complete book in PDF
» Feedback
Content starts here

 » Table of Contents

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.

Although not part of ODBTK, the functionality provided by the cpushares keyword in the WLM configuration file fits quite nicely with the toolkit.

cpushares keyword in WLM configuration file

The cpushares keyword allows shares-per-metric allocations. This enables you to create goal-based SLOs in WLM of the form “x CPU shares for each metric y.” (A CPU share is 1/100 of one core or 1/100 of each core, depending on WLM’s mode of operation. It is 1/1000 of one core or each core if extended_shares is enabled.) 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.

NOTE: The cpushares keyword is available starting with HP-UX WLM Version A.01.02.
Printable version
Privacy statement Using this site means you accept its terms Feedback to webmaster
© 2001-2007 Hewlett-Packard Development Company, L.P.