Index

A B C D E F G H I J L M N O P Q R S T U V W

A

ACL attributes, 5.1.4

ACTION, 1.3.5.3, 2.2

activating

Performance Policies, 4.4.4

active resource plan, 5.1.3

adding

classifiers to a Performance Class, 4.3.4.1

Performance Classes, 2.5

servers to server pools, 5.1.8

services to the Policy Set, 4.2.4

administrators

cluster, 3.1.2, 3.1.4, 5.1.4

creating for Oracle Database QoS Management, 4.6

creating the QoSAdmin user, 3.1.4

database, 5.1.4

initial configuration tasks, 3.1

OC4J, 4.6.1

Oracle Database QoS Management, 3.1.4

alerts

in Oracle Enterprise Manager, 1.3.8.1, 2.6

alternative recommendations, 1.3.8.3, 4.1.7

application contexts, 2.2

applications

classifying work requests, 1.3.5.2

definition, 1.4

parameters used by classifiers, 1.3.5.3

resource requirements, 1.3.3

supported connections, 2.1.4

APPQOS_PLAN, 3.1.5.1, 5.1.3

APPQOSSYS user, 3.1.5.1, 5.1.2

audit log, 2.6

Automatic Database Diagnostic Monitor (ADDM), 2.3.5

Automatic Workload Repository (AWR), 2.3.5

average response times

and Performance Classes, 2.5

and Performance Objectives, 1.3.6.1, 2.1.4

definition, 1.3.6.1, 1.5.1

B

batch jobs, 1.3.6.2

bequeath connections, 2.1.4

bottlenecks

and Performance Classes, 2.3.1, 4.5.3

and Performance Objectives, 1.5.4

and recommendations, 2.6

CPU resource, 2.3.2

for Performance Classes, 1.5.4

Global Cache resource, 2.3.3

I/O resource, 2.3.4

locating using metrics, 1.5.4

Other resource, 2.3.5

resolving, 1.3.8.3, 1.3.8.3

business objectives, 1.3.3

C

calendars, 1.3.2

candidate server lists, 3.1.2

classification rules

defaults, 1.3.5.2

classifiers, 1.3.5, 1.3.5.2, 2.2

adding, 4.3.4.1

and multiple services, 2.2, 4.3.1

and Performance Classes, 2.2, 4.3.1

and service names, 1.3.5.3

and session attributes, 2.2

and tags, 2.2

creating, 4.3.1

default_pc, 4.3.5

deleting, 4.3.4.3

evaluation order, 5.1.6

for the default Performance Class, 4.3.5

modifying, 4.3.4.2

multiple attributes, 2.2

order of evaluation, 2.2

session attributes, 2.2

specifying evaluation order, 4.2.1, 4.3.5

clients

Java Database Connectivity (JDBC) clients, 2.1.4

name of program, 2.2

Oracle Call Interface (OCI), 2.1.4

supported connections, 2.1.4

tracking across database sessions, 2.2

cluster administrator, 3.1.2, 3.1.4, 4.6, 5.1.4

Cluster Health Monitor, 1.4.2

configuration recommendations, 2.3

configuration violations, 2.1, 2.1.2

configuring

load balancing goals, 2.1.3

Oracle Grid Infrastructure for a cluster, 3.1

Oracle RAC databases, 3.1

Performance Objectives, 4.4.1

server pool directive overrides, 4.2.3, 4.4.2, 4.4.6

server pools, 2.1.1

connecting to a database, 2.1.3

connection load balancing, 2.1.3

connection pools, 2.1.3

connections

bequeath, 2.1.4

load balancing, 2.1.3

load balancing at runtime, 2.1.3

to databases, 2.1.4

consumer groups, 1.3.1, 1.4.1

recommendations, 1.3.8.2, 1.3.8.2

copying Performance Policies, 4.4.3

CPU resource bottlenecks

resolving, 2.3.2

CPU_COUNT, 5.1.5

and multiple databases, 2.1.2, 3.1.3

default value, 2.1.2, 3.1.3

Create Policy Set wizard, 3.1.5.2

creating

initial Policy Set, 3.1.5.2

Oracle Database QoS Management administrator user, 4.6

Performance Classes, 4.3.1

Performance Policies, 4.4.1

QoSAdmin user, 3.1.4

server pools, 3.1.2, 4.2.2

services, 3.1.3

CRSCTL, 5.1.4

D

Dashboard

accessing, 4.1.1

analysis result for recommendations, 4.1.6

and recommendations, 1.3.8.1

and resource bottlenecks, 2.3.1

and workload surges, 2.6

description of General section, 4.1.1

implementing recommendations, 4.1.8

logging in, 3.1.4

main sections, 4.1.1

Performance Overview, 4.1.1, 4.1.5

Performance Satisfaction Metric chart, 4.1.5

QoS Status, 4.1.1

recommendations not generated, 5.1.7

Recommendations section, 4.1.1

Resource Use vs. Wait Time chart, 4.1.5

Resource Wait Times Breakdown, 4.1.1, 4.5.3

Situation Analysis, 4.1.7

viewing recommendation details, 4.1.7

viewing recommendations, 4.1.6

Database Configuration Assistant (DBCA), 3.1.2

database connections, 1.3.1

database parameters, 1.4.3

Database Resource Manager

See Oracle Database Resource Manager

database services

See services

database sessions

tracking client calls, 2.2

databases

adding services, 4.2.4

and CPU_COUNT, 2.1.2, 3.1.3

compliant, 5.1.2

connecting with a service, 2.1.3

connections, 2.1.4

default service, 2.1.3

enabling Oracle Database QoS Management, 5.1.2

Oracle RAC One Node, 2.1.2

policy-managed, 1.3.4, 2.1.2, 5.1.2

services, 2.1.2

sharing a server pool, 2.1.2

singleton, 2.1.2

upgrading, 1.3.4

defaults

and classifiers, 4.3.5

and CPU_COUNT, 2.1.2, 3.1.3

database services, 2.1.3

namespace, 2.2

OC4J_PORT, 5.1.9

password for QoSAdmin user, 4.6.1

Performance Policy, 2.5, 4.2.1

Policy Set, 1.3.2, 2.4.3

QoSAdmin password, 3.1.4

rank, 2.5

deleting

classifiers for a Performance Class, 4.3.4.3

Performance Classes, 4.3.2

Performance Policies, 4.4.5

demand

changing levels of, 1.3.3

surges, 1.1, 1.3.1, 1.3.3, 1.3.8

disabling

Oracle Database QoS Management for a cluster, 4.1.3

E

Edit Policy Set wizard, 4.2, 4.2.1, 4.3.1, 4.3.2, 4.3.3, 4.3.4

enabling

Oracle Database QoS Management, 3.1.5

Oracle Database QoS Management for a cluster, 2.4.3, 3.1.5.3, 4.1.3, 5.1.1

Oracle Database QoS Management for a database, 5.1.2

tracing, 5.3

Enterprise Manager

integration with Oracle Database QoS Management server, 1.3.7

evaluating classifiers, 4.3.1

evaluation order of classifiers, 4.3.5

F

fast application notification (FAN), 2.1.3

FAST_START_MTTR_TARGET, 1.4.3

floaters, 2.5

Free pool, 1.3.4, 2.1.1, 3.1.2

G

Generic pool, 2.1.1

Global Cache resource bottlenecks

resolving, 2.3.3

goals

and services, 2.1.3

LONG, 2.1.3

SEVICE_TIME, 2.1.3

SHORT, 2.1.3

THROUGHPUT, 2.1.3

GV$ view queries, 2.1.4

H

headroom, 4.1.5

maximizing, 2.5

high availability, 1.4.3

I

implementing

alternative recommendations, 4.1.7

recommendations, 4.1.8

initial Policy Set, 3.1.5.2

initialization parameters

CPU_COUNT, 2.1.2, 3.1.3

I/O resource bottlenecks

resolving, 2.3.4

J

Java Database Connectivity, 1.3.1, 1.3.5.3

clients, 2.1.4

JDBC

See Java Database Connectivity

L

load balancing, 2.1.3

configuring goals for a service, 2.1.3

connections, 2.1.3

runtime connection, 2.1.3

load balancing advisory, 2.1.3

data, 2.1.3

goal, 1.3.1, 2.1.3

log files, 5.2

M

maintenance windows, 1.3.2

managed server pools

and Oracle RAC database instances, 2.1.2

managing

server pools, 3.1.5.2, 5.1.5

users, 4.6

measure-only, 4.4.1

Performance Classes, 1.3.6.1, 4.4.1, 4.4.2

Performance Policies, 2.5

measure-only mode, 2.5

memory

pressure, 1.4.2

running out of, 1.4.2

stress, 1.4.2

metrics, 1.5

collecting, 1.3.7

for performance, 1.5.1

for Performance Classes, 4.1.1

for resources, 1.5.2

not displayed, 5.1.6

performance satisfaction, 1.5.3

minimum response times, 2.5

minimum size of server pools, 2.5

modifying

classifiers for a Performance Class, 4.3.4.2

Performance Classes, 4.3.4

Performance Policies, 4.4.2

server pool settings, 4.2.3

MODULE, 1.3.5.3, 2.2

multi-tier environments, 2.2

N

namespaces

default, 2.2

O

OC4J, 4.6

administrator, 4.6.1

default port, 5.1.9

OC4J container, 2.6

locating, 3.1.4

OC4J_PORT environment variable, 5.1.9

OCI

See Oracle Call Interface

OCIAttrSet function, 2.2

ODP.NET, 1.3.5.3

OLTP workloads, 2.1.4

open workloads, 1.1

Oracle Call Interface, 1.3.1, 1.3.5.3

clients, 2.1.4

Oracle Clusterware Repository, 3.1.5.1, 4.6

Oracle Database QoS Management

administrator, 3.1, 3.1.4

changing active Performance Policy, 4.1.4

Dashboard

P

parallel queries, 2.1.4

Performance Classes, 1.3.2, 1.3.5, 1.3.5.3, 1.5.3, 2.6, 4.4.1

adding, 2.5

adding classifiers, 4.3.4.1

adding services, 4.2.4

and alerts, 2.6

and classifiers, 2.2

and homogenous calls, 2.1.4

and services, 1.3.5.2

changing the rank, 4.4.2

classifier ordering, 5.1.6

classifiers, 2.2

configuring Performance Objectives, 4.1.5

creating, 4.3.1

creating classifiers, 4.3.1

default, 4.3.5

default names, 1.3.2

default rank, 2.5

deleting, 4.3.2

deleting classifiers, 4.3.4.3

evaluating classifiers, 4.3.1

improvements in performance, 1.3.8.3

Incomplete data, 5.1.6

list of, 4.1.1

managing work requests separately, 1.3.5.4

maximum, 2.2

measure-only, 1.3.6.1, 4.1.5

metrics, 4.1.1

metrics missing, 5.1.6

modifying, 4.3.4

modifying classifiers, 4.3.4.2

multiple classifiers, 4.3.1

No demand, 5.1.6

Nonconforming data, 5.1.6

projected impact of recommendations, 1.3.7

ranks, 1.3.6.3

relation to Performance Objectives, 1.3.6.1

renaming, 4.3.3

satisfying Performance Objectives, 1.3.7

setting evaluation order of classifiers, 4.2.1

specifying evaluation order of classifiers, 4.3.5

specifying ranks, 4.4.1

suggested by application developer, 1.3.5.4

unable to collect metrics, 5.1.5

used in Performance Policies, 2.5

viewing performance metrics, 4.1.5, 4.5.1, 4.5.2

viewing resource wait times, 4.1.1

wait times for resources, 4.5.3

performance metrics, 1.5.1

Performance Objectives, 1.3.2, 1.5.3

and services, 2.5

configuring, 4.1.5

definition, 1.3.6.1

managing, 1.3.6

ranks, 1.3.8, 2.5

relation to Performance Classes, 1.3.6.1

specifying, 4.4.1

specifying values, 4.4.1

performance objectives

importance, 1.3.6

supported types, 2.1.4

Performance Policies, 1.3.2, 1.3.6.1, 1.3.8

activating, 4.4.4

and server pools, 2.1.1

changing active, 4.1.4

copying, 4.4.3

creating, 4.4.1

creating additional, 2.5

default, 2.5

Default policy, 4.2.1

definition, 1.3.6

deleting, 4.4.5

measure-only, 2.5

modifying, 4.4.2

ranking Performance Classes, 1.3.6.3

refining with Performance Classes, 2.5

server pool directive overrides, 1.3.6.2

performance projections, 2.6

Performance Satisfaction Metric (PSM), 1.5.3, 2.6, 4.1.5, 4.1.5, 4.4.1

performance tuning, 2.3.5

Policy and Performance Management engine, 1.3.7

policy changes

logs, 2.6

Policy Set

active policy, 4.1.1

adding server pools, 4.2.2

administrating, 4.2

creating a new Policy Set, 4.2

current policy, 4.1.1

default, 1.3.2

initial, 1.3.2

modifying, 4.2.1

Policy Set wizard

Define Classifier page, 2.5

Policy Sets, 1.3.2

contents, 1.3.2

creating, 3.1.5.2

default, 1.3.5.2, 2.4.3

default settings, 3.1.5.2

policy-managed databases, 2.1.2, 5.1.2

PROGRAM, 1.3.5.3, 2.2

Q

QoS administrator

initial configuration tasks, 3.1

qosadmin, 3.1.4

QoSAdmin user, 3.1.4, 4.1.1

default password, 3.1.4, 4.6.1

qosctl, 3.1.4

QOSCTL utility, 4.6

command reference, 4.6.1

syntax, 4.6.1

R

ranking Performance Objectives, 2.5

ranks

and Performance Classes, 1.3.6.3, 4.4.2

default, 2.5

Performance Classes, 4.4.1

recommendations, 1.3.2, 1.3.7, 1.4.3, 2.6, 4.5.3

alternative, 1.3.8.3

alternatives, 1.3.8.3, 4.1.7

analysis results, 4.1.6

choosing a different action, 4.1.7

consumer group mappings, 1.3.8.2, 1.3.8.2

generating, 1.3.8.3

implementing, 1.3.8.1, 1.3.8.3, 4.1.8

implementing alternative recommendations, 4.1.7

interval, 4.1.5

iterations, 1.3.8.6

negative impacts, 1.3.8.3

not being displayed, 4.1.8

not generated, 5.1.7

reallocating servers, 1.3.8.2

section of the Dashboard, 4.1.1

Situation Analysis, 4.1.7

viewing, 4.1.1, 4.1.6

viewing details, 4.1.7

Recommended Actions page, 4.1.7

removing servers from a server pool, 2.1.1

renaming

Performance Classes, 4.3.3

requirements

system, 2.1, 2.3

resolving

CPU resource bottlenecks, 2.3.2

Global Cache resource bottlenecks, 2.3.3

I/O resource bottlenecks, 2.3.4

Other resource bottlenecks, 2.3.5

resource bottlenecks

resolving, 2.3.5

Resource Manager

See Oracle Database Resource Manager

resource plans

APPQOS_PLAN, 3.1.5.1, 5.1.3

used by Oracle Database QoS Management, 1.4.1.2

resource types, 2.3.1

bottlenecked, 4.5.3

CPU, 2.3.2

Global Cache, 2.3.3

I/O, 2.3.4

OC4J, 5.1.9

Other, 2.3.5

viewing wait times, 4.1.1

Resource Use vs. Wait Time chart, 4.1.5

resources

allocating, 1.3.1

bottlenecks

and recommendations, 1.3.7

increasing CPU access, 1.3.8.6

resolving bottlenecks, 1.3.8.3

starved, 1.3.8.2

types of, 1.5.2

usage, 1.5.2

wait times, 1.5.2

waits, 1.5

response time, 1.3.6.1

response times

average per call, 2.1.4

definition, 1.5

minimum achievable, 2.5

RMI port conflict, 5.1.9

runtime connection load balancing, 2.1.3

runtime connection load balancing goal, 1.3.1

S

server pool directive overrides, 2.5

configuring, 4.2.3, 4.4.6

specifying, 4.4.2

valid values, 4.4.6

server pools, 1.3.1, 1.3.2, 1.3.3, 2.1.1

accessing, 3.1, 5.1.4

adding to a Policy Set, 4.2.2

adjusting size of, 1.4.1

and multiple databases, 2.1.2

and recommendations, 1.3.8.2

and services, 1.4.1.1

attributes, 1.3.6.2

candidate server lists, 1.3.4, 3.1.2

configuring, 2.1.1

constraints, 2.4.1

creating, 3.1.2, 4.2.2

directive overrides, 1.3.6.2

execute permission, 5.1.4

Free pool, 1.3.4, 3.1.2

increasing minimum pool size, 4.4.6

list of, 4.1.1

managed, 2.1.1, 2.1.2

marked as managed, 3.1.5.2

maximum size of one, 2.1.2, 2.1.3, 2.1.3, 5.1.5

minimum size, 1.3.8.2, 1.3.8.2, 2.5, 3.1

minimum size of one, 2.1.1

modifying settings, 4.2.3

modifying using Oracle Enterprise Manager, 4.2.3

privileges, 3.1.2

removing servers from, 2.1.1

selecting for management, 4.2.1

SERVER_NAMES attribute, 3.1.2

servers not added, 5.1.8

unmanageable, 5.1.5

unmanaged, 2.1.1

using multiple server pools, 1.3.3

viewing current settings, 4.2.1

SERVER_NAMES attribute, 3.1.2

servers

added to wrong server pool, 5.1.8

hosting the Oracle Database QoS Management server, 2.6

service levels, 1.3.6.1, 1.4.2

SERVICE_NAME, 1.3.5.3

SERVICE_TIME, 1.3.1

service-level agreements (SLAs), 1.3.8.6, 2.4.3, 2.5, 2.5, 2.6, 4.4.1

services, 1.3.1

adding to the Policy Set, 4.2.4

and Oracle Clusterware, 2.1.3

and work requests, 1.4.1.1

configuring load balancing goals, 2.1.3

creating, 3.1.3

default database service, 2.1.3

defaults

Performance Classes, 1.3.5.2

discovered automatically, 2.4.3

for database connections, 2.1.4

load balancing, 2.1.3

names, 2.2

SINGLETON, 2.1.2, 2.1.3, 5.1.5

singleton, 1.4.1.1

specifying multiple, 4.3.1

transactional shut down, 1.3.8.6

UNIFORM, 2.1.2, 2.1.3

used by workloads, 2.1.3

session attributes, 2.2

ACTION, 2.2

and classifiers, 2.2

MODULE, 2.2

program, 2.2

user name, 2.2

sessions

rerouting, 1.4.2

Set Policy, 4.4.4

singleton databases, 2.1.2

SINGLETON services, 2.1.3, 5.1.5

Situation Analysis, 4.1.7

SLA

See service-level agreements

SQL performance issues, 2.3.5

SRVCTL, 2.1.3, 4.2.2, 4.6, 5.1.4, 5.1.9

storage interconnect, 2.3.4

supported

connection types, 2.1.4

Oracle RAC database releases, 2.1.2

response times, 2.1.4

workloads, 1.4, 1.5.3, 2.1.4

swap

memory, 1.4.2

system parameters, 1.4.3

system performance

evaluating, 1.3.7, 1.3.8.3

system requirements, 2.1, 2.3

T

tagging, 1.3.5.3

tags, 1.3.5, 2.2

and classifiers, 2.2

for work requests, 1.3.5.3

trace files, 5.2

tracing

enabling, 5.3

troubleshooting

enabling Oracle Database QoS Management for a cluster, 5.1.1

enabling Oracle Database QoS Management for a database, 5.1.2

U

UNIFORM services, 2.1.3

user name, 2.2

USERENV namespace, 2.2

USERNAME, 1.3.5.3

users

APPQOSSYS, 5.1.2

creating administrators, 4.6

default for QoSAdmin, 4.6.1

V

viewing

current server pool settings, 4.2.1

latest analysis results, 4.1.6

performance metrics, 4.5.1, 4.5.2

recommendation details, 4.1.7

recommendations, 4.1.6

resource wait times, 4.5.3

violations, 3.1.5

and CPU_COUNT, 3.1.3

configuration, 2.1, 2.1.2, 4.2.1

for Performance Objectives, 2.6

logs, 2.6

resource plan not enabled, 5.1.3

viewing, 4.1.1

W

wait times, 1.5, 2.3.5

for resources, 4.5.3

viewing, 4.1.1

wizards

Create Policy Set, 3.1.5.2

Edit Policy Set, 4.2, 4.2.1, 4.3.1, 4.3.2, 4.3.3, 4.3.4

Policy Set, 2.5

work requests, 1.1, 1.3.5, 1.3.5.3

and services, 1.4.1.1

and tags, 1.3.5.2

creating classifiers, 4.3.1

definition, 1.4

managing separately, 1.3.5.4

metrics, 1.5

workloads, 1.3.8

and creating new Performance Classes, 2.1.4

and GV$ view calls, 2.1.4

and parallel queries, 2.1.4

and server pools, 1.3.3

calls and Performance Classes, 2.2

consolidating, 1.3.3

database connections, 1.3.5.3

different resource requirements for call subsets, 2.1.4

managing, 2.2

monitoring, 1.3.1

OLTP, 2.1.4

scaling, 1.3.3