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 53
Step 7. Once you have a feel for how the components work together, modify the
my_shares_per_user.wlm file to perform the SQL queries needed in your
environment.
For additional example configuration files that you can modify to better
fit your needs, see the files ending in “.wlm” in the following directory:
/opt/wlm/toolkits/oracle/config/
Executing a query to get response time
The configuration in this section executes a timed query. The CPU
allocation for the instance’s workload group is increased to keep the
response time under 2.5 seconds. Note that this goal value would change
based on the hardware, software, and parameters.
To implement this configuration:
Step 1. Install the SCOTT/TIGER examples that come with Oracle databases.
Step 2. Copy the timed_select_scott.wlm file to your local directory and rename
it:
# cp /opt/wlm/toolkits/oracle/config/timed_select_scott.wlm \
./my_timed_select_scott.wlm
Step 3. Edit the my_timed_select_scott.wlm file:
a. To be specific to your instance by changing the instance strings
b. So that the oracle paths match your $ORACLE_HOME
Step 4. Check the syntax of your my_timed_select_scott.wlm file:
# wlmd -c my_timed_select_scott.wlm
Step 5. Fix any errors with the file. If there are no errors, activate the
configuration:
# wlmd -a my_timed_select_scott.wlm
For information on additional example configuration files that you can
modify to better fit your needs, see Table 2-2 on page 35 and Table 2-3 on
page 37.