HP-UX Workload Manager Toolkits User's Guide

HP-UX WLM Oracle Database Toolkit: Providing Database Metrics to WLM
Supported installations
Chapter 222
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
Supported installations
The tools discussed in this document work with:
• HP-UX WLM Version A.03.02 on HP-UX 11i v1 (B.11.11), HP-UX 11i
v2 (B.11.23), and HP-UX 11i v3 (B.11.31)
• HP-UX WLM Version A.03.01 on HP-UX 11i v1 (B.11.11) and HP-UX
11i v2 (B.11.23)
• HP-UX WLM Version A.03.00 on HP-UX 11i V1 (B.11.11) and
HP-UX v2 (B.11.23)
• HP-UX WLM Version A.02.03 on HP-UX 11i V1 (B.11.11) and
HP-UX v2 (B.11.23)
• HP-UX WLM Version A.02.02 on HP-UX 11i v1 (B.11.11) and HP-UX
11i v2 (B.11.23)
• HP-UX WLM Version A.02.01.01 on HP-UX 11i v2 (B.11.23)
• HP-UX WLM Version A.02.01 on HP-UX 11i v1 (B.11.11)
• HP-UX WLM Version A.01.02 (which is the first version to include
the cpushares keyword) on HP-UX 11i v1 (B.11.11)
• Oracle 8.0.x, Oracle 8.1.5, Oracle 8.1.6, Oracle 8.1.7, and Oracle 9.0.1