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 234
How do I use the metrics?
To use the Oracle database metrics:
1. Determine a useful example WLM configuration file.
2. Customize the WLM configuration file.
3. (Optional) Customize an example wlmoradc configuration file.
4. Check the WLM configuration file’s syntax with wlmd -c.
5. Activate the WLM configuration file with wlmd -a.
If none of the example WLM configuration files are useful to you,
consider the following approach:
1. Define workload groups in a WLM configuration file for your Oracle
instances.
2. Decide which metrics you want to collect.
3. Implement the SQL statements to retrieve the desired metrics. Place
these statements in an wlmoradc configuration file or in the WLM
configuration file as an option to the wlmoradc utility.
4. Specify wlmoradc in the WLM configuration file as a data collector
for WLM.
5. Check the WLM configuration file’s syntax with wlmd -c.
6. Activate the WLM configuration file with wlmd -a.
The following steps discuss the first approach, where you customize an
example WLM configuration file.