Chapter 2 HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM

The HP-UX Workload Manager Oracle® Database Toolkit is a collection of utilities that simplify getting metrics on Oracle database instances into HP-UX Workload Manager, also known as HP-UX WLM.

WLM enables you to place Oracle instances and other applications in their own WLM workload groups. With the instances and applications separated in this manner, WLM can then manage the performance of each instance and application through prioritized SLOs. These SLOs typically attempt to ensure:

A consistent level of performance for the workload
The needs of critical instances are met—even during peak demand
Resources are allocated based on time of day, system events, or application and database metrics

For more information on WLM, see the HP-UX Workload Manager User’s Guide or wlm(5).

The tools in the WLM Oracle Database Toolkit (ODBTK) make it easy to use metrics from Oracle database instances as goal values in service-level objectives. These metrics can also be used to enable or disable SLOs based on database conditions.

These tools were designed with the following goals in mind:

Simplify getting the data to answer the question: “When does my Oracle instance need more CPU resources to meet business objectives?” Toward this end, the tools provide a simple method for getting the following metrics to WLM:
- Wallclock time consumed by a piece of SQL code (the amount of time it takes for the SQL code to execute)
- A single floating-point value from a piece of SQL code
Not require modifications to the application or the database
Be easy to use quickly by providing useful examples, instructions, and pointers for additional information

Chapter 2 HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM

Technical documentation

» Table of Contents