WLMTK Overview: Using HP-UX WLM Effectively With Your Most Critical Applications

11
How to use ODBTK
ODBTK comes with numerous example configuration files for both WLM and the included wlmoradc
tool. Look at these files to understand how to use ODBTK with WLM. After determining how you want
to measure your instances, you can copy and modify the WLM configuration files to reduce your
implementation time. Also, ensure to look at the wlmoradc example configuration files. These files
store SQL statements, among other items. The example files provide the SQL statements for retrieving
the number of user connections or the number of processes for an instance.
Use ODBTK to provide Oracle database metrics to WLM by performing the following procedure:
1. Determine which example WLM configuration file is appropriate.
2. Customize the WLM configuration file.
3. (Optional) Customize an example wlmoradc configuration file.
4. Verify the WLM configuration file 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 workloads 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 a
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. Verify the WLM configuration file syntax with wlmd –c, and fix any errors.
6. Activate the WLM configuration file with wlmd -a.
Example configuration files
ODBTK offers the following example WLM configuration files:
• alpha_shares_per_user.wlm—Demonstrates how to customize a supplied WLM configuration file
(each Oracle instance is allocated CPU shares based on the number of users connected to the
instance). The HP-UX Workload Manager Toolkits User’s Guide shows how to customize a supplied
file, shares_per_user.wlm, for a particular set of instances. alpha_shares_per_user.wlm is the result
of that customization and is included in this list for educational purposes.
• batchuser_boost.wlm—Demonstrates a conditional allocation example. Each instance has a fixed
minimum allocation and gets a “boost” if user BATCHUSER connects to the instance.
• manual_payroll_boost.wlm—Demonstrates a conditional allocation example in which the condition
can be triggered from the command line using the wlmsend utility.
• shares_per_process.wlm—Demonstrates a parametric allocation. Each instance gets five CPU
shares per process. It is similar to the shares_per_user.wlm example.
• shares_per_user.wlm—Demonstrates a parametric allocation. Each instance gets three CPU shares
per user connection. It is similar to the shares_per_process.wlm example.
• timed_select_scott.wlm—Demonstrates a response time goal with the SCOTT/TIGER Oracle
documentation example tables.
• timed_sys_table.wlm—Demonstrates a response time goal with a contrived join (database
operation) on a pair of V$ Oracle system tables.
• user_cnt_boost.wlm—Demonstrates a conditional allocation example. Each instance has a fixed
minimum allocation and gets a ”boost” if more than 10 users connect.