HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
What metrics are available?
Chapter 226
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.
What metrics are available?
The following types of database metrics are available:
• Time elapsed while a user-defined set of SQL code executes
This provides a response-time measurement for the database
• Application-specific value returned by executed SQL code
• Information retrieved from Oracle V$ tables using SQL
These tables provide dynamic performance data for Oracle instances
and allow the Oracle DBA to see current performance information.