HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
How do I use the metrics?
Chapter 2 35
Step 1. Determine a useful example WLM configuration file.
Example configurations are available in /opt/wlm/toolkits/oracle/config/.
Choose a file that provides metrics matching the type you need.
Table 2-2 describes the available example files.
* Requires WLM A.01.02 or later
Table 2-2 WLM example configuration files described
WLM configuration file Purpose
alpha_shares_per_user.wlm
*
Demonstrate how to customize the supplied file
shares_per_user.wlm for a slightly different set of
instances
batchuser_boost.wlm Demonstrate a conditional allocation: Each instance has a
fixed minimum allocation and gets a boost if a certain user
connects to the instance
manual_payroll_boost.wlm Demonstrate a conditional allocation, with the allocation
enforced when a certain application becomes active; also,
demonstrate how to feed “external” metrics to WLM using
wlmsend
shares_per_process.wlm
*
Demonstrate an allocation where each instance gets a
certain number of CPU shares per process
shares_per_user.wlm
*
Demonstrate an allocation where each instance gets a
certain number of CPU shares per user connection
timed_select_scott.wlm Demonstrate a response-time goal using a SCOTT/TIGER
table
timed_sys_table.wlm Demonstrate a response-time goal using V$ Oracle system
tables
user_cnt_boost.wlm Demonstrate a conditional allocation, with a new
allocation enforced when more than a set number of users
connect