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 252
Executing a query to get an SQL value
In this section, the configuration has an SLO that increases the
workload’s CPU resources as the number of active connections (or users)
increases. To implement this configuration:
Step 1. Copy the shares_per_user.wlm file to your local directory and rename it:
# cp /opt/wlm/toolkits/oracle/config/shares_per_user.wlm \
./my_shares_per_user.wlm
Step 2. Edit the file my_shares_per_user.wlm:
a. To be specific to your instance by changing the instance strings
b. So that the oracle paths match your $ORACLE_HOME
Step 3. Check the syntax of your my_shares_per_user.wlm file:
# wlmd -c my_shares_per_user.wlm
Step 4. Fix any errors with the file. If there are no errors, activate the
configuration:
# wlmd -a my_shares_per_user.wlm
Step 5. Use wlminfo to view CPU allocations by workload group. Invoke the
command as follows to show allocations with live updates:
# /opt/wlm/bin/wlminfo group -l
Keep the wlminfo output visible.
Step 6. Connect to your instance with SQL*Plus and watch the allocation for the
instance’s workload group grow as the number of active connections
increases.
NOTE If you have any difficulties, use the tail command to look at the end of
the following file:
/var/adm/syslog/syslog.log
Look for warnings and errors originating from the WLMTK facility.