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 45

• A Pro*C-based application, zeus_app, is used with instance beta, so

it has an application record that places it in the workload group

beta_grp.

# Name:

# alpha_shares_per_user.wlm

# Version information:

# $Revision: 1.21 $

# 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:

# Example configuration file for fictional Oracle instances and

# applications for the HP-UX Workload Manager Oracle Database Toolkit

# User’s Guide. This configuration demonstrates how to copy and

# modify the shares_per_user.wlm configuration for a set of Oracle

# instances. See the User’s Guide for an explanation of the process.

# Independently control CPU allocation by number of user

# connections for three database instances, alpha, beta, gamma.

# Set aside remaining CPU resources for the common workload group

# hosting the database instances larry, moe, and curly.

# 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.