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 242
# prm structure
# Define three workload groups. The first two groups are for
# Oracle instances. The third group, called long_batch, is for
# other work being done on the server.
#
# The ‘apps’ definitions place the applications in workload
# groups. Note that the two Oracle instances each have a
# Pro*C-based application: /workload1/oltp1 and /workload2/oltp2.
# These applications run in the same workload groups as their
# respective instances.
#
# Because Oracle processes rename themselves, we have HP-UX WLM
# place processes in workload groups based on their alternate
# names. In this case, those alternate names will be
# “ora*instance1” and “ora*instance2”.
#
# See wlmconf(4) for complete HP-UX WLM configuration information.
#
prm {
groups = OTHERS : 1,
ora1_grp : 2,
ora2_grp : 3,
long_batch : 4;
apps = ora1_grp:/oracle/app/oracle/product/8.1.5/bin/oracle
“ora*instance1”,
ora1_grp:/workload1/oltp1,
ora2_grp:/oracle/app/oracle/product/8.1.5/bin/oracle
“ora*instance2”,
ora2_grp:/workload2/oltp2,
long_batch:/oracle/demo/batch/long_batch;
}
#
# Have HP-UX WLM give workload ora1_grp three CPU shares for each user
# connected to the associated Oracle instance. See the tune structure below
# for details on how the user counts are collected.
#
slo ora1_slo {
pri = 1;
mincpu = 5;
maxcpu = 90;
entity = PRM group ora1_grp;
cpushares = 3 total per metric oracle.instance1.user_cnt;
}