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 41

You can set up these commands to be triggered:

•By cron on a regular interval

• Manually when the SLO needs to be met

• From inside SQL or via the HOST or ‘!’ commands

How do I customize an example WLM configuration

file?

To illustrate how to customize a WLM configuration file, consider the file

/opt/wlm/toolkits/oracle/config/shares_per_user.wlm as shown:

# Name:

# shares_per_user.wlm

# Version information:

# $Revision: 1.35 $

# Caveats:

# DO NOT MODIFY this script in its /opt/wlm/toolkits location!

# Make modifications to a copy and place that copy outside the

# /opt/wlm/ directory, as items below /opt/wlm will be replaced

# or modified by future HP-UX WLM product updates.

# Purpose:

# Demonstrate a parametric allocation: Each Oracle instance gets

# three CPU shares per user connection. Also see the

# shares_per_process.wlm example.

# Components:

# Uses the user_cnt.oradc file with wlmoradc to count user connections.

# Dependencies:

# This example was designed to run with HP-UX WLM version A.02.01

# or later. It uses the coll_stderr keyword introduced in A.02.01

# and is, consequently, incompatible with earlier versions of

# HP-UX WLM.