HP-UX Workload Manager User's Guide

Integration with other products
Integrating with Oracle® databases
Appendix D 429
What metrics are available?
The following types of database metrics are available:
• Time elapsed while SQL code executes
• Value returned by executed SQL code
This value can be information from Oracle V$ tables. These tables
provide dynamic performance data for Oracle instances and allow
the Oracle database administrator to see current performance
information.
How do I get started with ODBTK?
The toolkit comes with numerous example files that you can copy and
modify to fit your needs. These files include WLM configuration files and
wlmoradc configuration files, which include SQL.
The files are available in /opt/wlm/toolkits/oracle/config/. Table D-1
describes the WLM example configuration files.
Table D-1 ODBTK’s example WLM configuration files described
WLM configuration file Purpose
alpha_shares_per_user.wlm Demonstrate how to customize the supplied file
shares_per_user.wlm for a slightly different set of instances
batchuser_boost.wlm Demonstrate a conditional allocation, with the allocation
enforced when a certain user connects
manual_payroll_boost.wlm Demonstrate a conditional allocation, with the allocation
enforced when a certain application becomes active; also,
demonstrate how to feed “external” metrics to WLM using
wlmsend
shares_per_process.wlm Demonstrate an allocation where each instance gets a
certain number of CPU shares per process
shares_per_user.wlm Demonstrate an allocation where each instance gets a
certain number of CPU shares per user connection
timed_select_scott.wlm Demonstrate a response-time goal using a SCOTT/TIGER
table