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 37
g. Create an application record in the prm structure in the configuration
file for each instance by modifying the existing application records.
For example, consider this line from
/opt/wlm/toolkits/oracle/config/manual_payroll_boost.wlm:
apps = Ora_grp_1:/oracle/app/oracle/product/8.1.5/bin/oracle "ora*instance1",
Here, you would change the oracle path to match the $ORACLE_HOME
setting for the instance. Also, you would change “ora*instance1” to
reflect the actual name of the instance. The processes from your
instance would be placed in the workload Ora_grp_1 unless you
change your workload definitions.
For more information on placing instances in workload groups, see
“How do I place instances in workload groups?” on page 49.
For an example illustrating how to customize a WLM configuration
file, see the section “How do I customize an example WLM
configuration file?” on page 41.
Step 3. (Optional) Customize an example wlmoradc configuration file.
Copy the wlmoradc configuration files from the
/opt/wlm/toolkits/oracle/config/ directory and customize them as needed.
This step is optional because you can place many of the items from the
file on the command line; the file is mainly for convenience. These files
have a “.oradc” extension and can be used to set database environment
variables. Also, you can place SQL statements in these files. Table 2-3
describes the available files.
Table 2-3 wlmoradc example configuration files described
wlmoradc configuration
file
Purpose
process_cnt.oradc Report number of user processes using
an instance
select_scott_resptime.oradc Demonstrate a timed proxy
transaction with the SCOTT/TIGER
tables
sys_table_resptime.oradc Demonstrate a timed proxy
transaction against V$ Oracle system
tables