Tools in WLM Oracle Database Toolkit (ODBTK)

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.

	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.

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.