Index

A

access control
- support for Oracle ASM
ACL attributes 5.1.4
ACTION 1.3.5.3, 2.2
activating
- Performance Policies 4.6.4.2
active resource plan 5.1.3
adding
- classifiers to a Performance Class 4.5.4.1
- servers to server pools 5.1.8
- services to the Policy Set 4.4.4, 4.4.5
administrator-managed databases
- support for , 1.3.4
administrators
- cluster 3.1.2, 3.1.4, 5.1.4
- creating for Oracle Database QoS Management 4.8
- creating the QoSAdmin user 3.1.4
- database 5.1.4
- initial configuration tasks 3.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.3.6
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
- editing 4.9
APPQOSSYS user 3.1.5.1, 5.1.2
audit log 2.6
authorized actions , 4.6.1, 4.6.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.7.4
- 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
business objectives 1.3.3

C

calendars 1.3.2
candidate server lists 3.1.2
CDB 1.3.8.2.4, 1.4.1.2
CGroups 3.1.6
CHM
classification rules
- defaults 1.3.5.2
classifiers 1.3.5, 1.3.5.2, 2.2
- adding 4.5.4.1
- and multiple services 2.2, 4.5.1
- and Performance Classes 2.2, 4.5.1
- and service names 1.3.5.3
- and session attributes 2.2
- and tags 2.2
- creating 4.5.1
- default_pc 4.5.5
- deleting 4.5.4.3
- evaluation order 5.1.6
- for the default Performance Class 4.5.5
- modifying 4.5.4.2
- multiple attributes 2.2
- order of evaluation 2.2
- session attributes 2.2
- specifying evaluation order 4.4.1, 4.5.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.8, 5.1.4
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.6.1
- server pool directive overrides 4.4.3, 4.6.2, 4.6.7
- 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 run time 2.1.3
- to databases 2.1.4
consumer groups 1.3.1.1, 1.4.1
- recommendations 1.3.8.2, 1.3.8.2.1
container database 1.3.8.2.4
container database (CDB) 2.1.2
control groups 3.1.6
copying Performance Policies 4.6.3
CPU_COUNT 1.3.1.2, 5.1.5
- and multiple databases 2.1.2, 3.1.3.1
- default value 2.1.2, 3.1.3.1
CPU partition 1.3.1.2
CPU resource bottlenecks
- resolving 2.3.2
CPU shares 1.3.8.2.4
Create Policy Set wizard 3.1.5.2
creating
- initial Policy Set 3.1.5.2
- Oracle Database QoS Management administrator user 4.8
- Performance Classes 4.5.1
- Performance Policies 4.6.1
- QoSAdmin user 3.1.4
- server pools 3.1.2, 4.4.2
- services 3.1.3.2
CRSCTL 5.1.4

D

Dashboard
- accessing 4.3.1
- analysis result for recommendations 4.3.5
- and recommendations 1.3.8.1
- and resource bottlenecks 2.3.1
- and workload surges 2.6
- description of General section 4.3.1
- implementing recommendations 4.3.7
- logging in 3.1.4
- main sections 4.3.1
- Performance Overview 4.3.1, 4.3.4
- Performance Satisfaction Metric chart 4.3.4
- QoS Status 4.3.1
- recommendations not generated 5.1.7
- Recommendations section 4.3.1
- Resource Use vs. Wait Time chart 4.3.4
- Resource Wait Times Breakdown 4.3.1, 4.7.4
- Situation Analysis 4.3.6
- viewing recommendation details 4.3.6
- viewing recommendations 4.3.5
database
- startup order determined by rank 1.3.6.4
Database Configuration Assistant (DBCA) 3.1.2
database connections 1.3.1.3
database parameters 1.4.2
Database Resource Manager
- See: Oracle Database Resource Manager
databases
- adding services 4.4.4, 4.4.5
- and CPU_COUNT 2.1.2, 3.1.3.1
- 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
- startup order
- upgrading 1.3.4
database services
- See: services
database sessions
- tracking client requests 2.2
defaults
- and classifiers 4.5.5
- and CPU_COUNT 2.1.2, 3.1.3.1
- database services 2.1.3
- namespace 2.2
- password for QoSAdmin user 4.8.1
- Performance Policy 2.5, 4.4.1
- Policy Set 1.3.2, 2.4.3
- QoSAdmin password 3.1.4
deleting
- classifiers for a Performance Class 4.5.4.3
- Performance Classes 4.5.2
- Performance Policies 4.6.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.3.3

E

Edit Policy Set wizard 4.4, 4.4.1, 4.5.1, 4.5.2, 4.5.3, 4.5.4
enabling
- Oracle Database QoS Management 3.1.5
- Oracle Database QoS Management for a cluster 2.4.3, 3.1.5.3, 4.3.2, 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.5.1
evaluation order of classifiers 4.5.5

F

FAST_START_MTTR_TARGET 1.4.2
fast application notification (FAN) 2.1.3
floaters 2.5
Free pool 1.3.4, 3.1.2

G

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
Grid Infrastructure Management Repository
GV$ view queries 2.1.4

H

headroom 4.3.4
- maximizing 2.5
high availability 1.4.2

I

I/O resource bottlenecks
- resolving 2.3.4
implementing
- alternative recommendations 4.3.6
- automatic actions
- recommendations 4.3.7
initialization parameters
- CPU_COUNT 2.1.2, 3.1.3.1
initial Policy Set 3.1.5.2
instance caging 1.3.1.2, 3.1.6
IP addresses
- IPv6 support

J

Java Database Connectivity 1.3.1.3, 1.3.5.3
- clients 2.1.4
JDBC
- See: Java Database Connectivity

L

LMS processes 1.3.6.4
load balancing 2.1.3
- configuring goals for a service 2.1.3
- connections 2.1.3
- run-time connection 2.1.3
load balancing advisory 2.1.3
- data 2.1.3
- goal 1.3.1.3, 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.8
MCB
- See: Multi-CPU Binding
measure-only 4.6.1
- Performance Classes 1.3.6.1, 4.6.1, 4.6.2
- Performance Policies 2.5
measure-only mode , 2.5
MemoryGuard ,
memory pressure
metrics 1.5
- collecting 1.3.7
- for performance 1.5.1
- for Performance Classes 4.3.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.5.4.2
- Performance Classes 4.5.4
- Performance Policies 4.6.2
- server pool settings 4.4.3
MODULE 1.3.5.3, 2.2
Multi-CPU Binding 3.1.6
multitenant database 1.4.1.2
multitenant databases 2.1.2
multi-tier environments 2.2

N

namespaces
- default 2.2

O

OC4J container
- locating 3.1.4
OCI
- See: Oracle Call Interface
OCIAttrSet function 2.2
ODP.NET 1.3.5.3
OLTP workloads 2.1.4
open workloads 1.1
ORA$QOS_CDB_PLAN 5.1.3
- editing 4.9
ORA$QOS_PLAN
- editing 4.9
Oracle ASM
- access control
- patching
- role separation
Oracle Call Interface 1.3.1.3, 1.3.5.3
- clients 2.1.4
Oracle Cluster Health Monitor
Oracle Clusterware Repository 3.1.5.1, 4.8
Oracle Database QoS Management
- See also: Dashboard
- administrator 3.1, 3.1.4
- changing active Performance Policy 4.6.4.1, 4.6.4.3
- Dashboard 4.3.1
  - See also: Dashboard
- Dashboard sections 4.3.1
- disabling for a cluster 4.3.3
- enabling for a cluster 2.4.3, 3.1.5, 3.1.5.3, 4.3.2
- enabling for a database 3.1.5
- log files 5.2
- selecting server pools 4.4.1
- server hosting the OC4J container 3.1.4
- status 4.3.1
- trace files 5.2
- troubleshooting 5
- using the Dashboard 4.3.1
- viewing cluster management status 4.1.2
- viewing current status 3.1.5.3
Oracle Database QoS Management administrator 4.3.1
- creating 3.1.4
- default password 3.1.4
Oracle Database Resource Manager 1.3.1.1, 1.4.1, 4.9
- enabling 5.1.3
Oracle Enterprise Manager alerts 2.6
Oracle Enterprise Manager Dashboard 1.3.8.1
- See also: Dashboard
Oracle RAC databases
- creating 3.1.2
- supported releases 2.1.2
Oracle RAC high availability framework 2.1.3
Oracle RAC One Node databases 2.1.2
Oracle Real Application Clusters (Oracle RAC) 1.4
- and Oracle Database QoS Management 1.4.1
Oracle Wallet 3.1.5.1
overloaded systems 1.3.8.2.3
overrides
- See: server pool directive overrides

P

parallel queries 2.1.4
patching
- Oracle ASM
PDB 1.4.1.2
PDB shares 1.4.1.2
performance class
- ranks 1.3.6.4
Performance Classes 1.3.2, 1.3.5, 1.3.5.3, 1.5.3, 2.6, 4.6.1
- adding classifiers 4.5.4.1
- adding services 4.4.4, 4.4.5
- and alerts 2.6
- and classifiers 2.2
- and homogenous requests 2.1.4
- and services 1.3.5.2
- changing the rank 4.6.2
- classifier ordering 5.1.6
- classifiers 2.2
- configuring Performance Objectives 4.3.4
- creating 4.5.1
- creating classifiers 4.5.1
- default 4.5.5
- default names 1.3.2
- deleting 4.5.2
- deleting classifiers 4.5.4.3
- evaluating classifiers 4.5.1
- improvements in performance 1.3.8.3
- Incomplete data 5.1.6
- list of 4.3.1
- managing work requests separately 1.3.5.4
- maximum 2.2
- measure-only , 1.3.6.1, 4.3.4
- metrics 4.3.1
- metrics missing 5.1.6
- modifying 4.5.4
- modifying classifiers 4.5.4.2
- multiple classifiers 4.5.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.5.3
- satisfying Performance Objectives 1.3.7
- setting evaluation order of classifiers 4.4.1
- specifying evaluation order of classifiers 4.5.5
- specifying ranks 4.6.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.3.4, 4.7.1, 4.7.2
- viewing resource wait times 4.3.1
- wait times for resources 4.7.4
performance metrics 1.5.1
performance objectives
- importance 1.3.6
- supported types 2.1.4
Performance Objectives 1.3.2, 1.5.3
- and services 2.5
- configuring 4.3.4
- 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.6.1
- specifying values 4.6.1
Performance Policies 1.3.2, 1.3.6.1, 1.3.8
- activating 4.6.4.2
- and server pools 2.1.1
- changing active 4.6.4.1, 4.6.4.3
- copying 4.6.3
- creating 4.6.1
- creating additional 2.5
- default 2.5
- Default policy 4.4.1
- definition 1.3.6
- deleting 4.6.5
- measure-only 2.5
- modifying 4.6.2
- ranking Performance Classes 1.3.6.3
- refining with Performance Classes 2.5
- scheduling the active policy 4.6.4.2
- server pool directive overrides 1.3.6.2
performance projections 2.6
Performance Satisfaction Metric (PSM) 1.5.3, 2.6, 4.3.4, 4.6.1
performance tuning 2.3.5
pluggable database (PDB) 2.1.2
pluggable databases
- monitoring 1.3.8.2.4
Policy and Performance Management engine 1.3.7
policy changes
- logs 2.6
policy-managed databases 2.1.2, 5.1.2
Policy Set
- active policy 4.3.1
- adding server pools 4.4.2
- administrating 4.4
- creating a new Policy Set 4.4
- current policy 4.3.1
- default 1.3.2
- initial 1.3.2
- modifying 4.4.1
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
PROGRAM 1.3.5.3, 2.2

Q

qosadmin 3.1.4
QoS administrator
- initial configuration tasks 3.1
QoSAdmin user 3.1.4, 4.3.1
- default password 3.1.4, 4.8.1
qosctl 3.1.4
QOSCTL utility 4.8
- syntax 4.8.1
qosmserver
- default port 5.1.9

R

ranking Performance Objectives 2.5
ranks
- and database startup order
- and Performance Classes 1.3.6.3, 4.6.2
- Performance Classes 4.6.1
recommendations 1.3.2, 1.3.7, 1.4.2, 2.6, 4.7.4
- alternatives 1.3.8.3, 4.3.6
- analysis results 4.3.5
- automatically implemented 4.6.6
- choosing a different action 4.3.6
- consumer group mappings 1.3.8.2, 1.3.8.2.1
- contents 1.3.8.4
- generating 1.3.8.3
- implementing 1.3.8.1, 1.3.8.3, 4.3.7
- implementing alternative recommendations 4.3.6
- interval 4.3.4
- iterations 1.3.8.6
- negative impacts 1.3.8.3
- not being displayed 4.3.7
- not generated 5.1.7
- reallocating servers 1.3.8.2.3
- section of the Dashboard 4.3.1
- Situation Analysis 4.3.6
- viewing 4.3.1, 4.3.5
- viewing details 4.3.6
Recommended Actions page 4.3.6
removing servers from a server pool 2.1.1
renaming
- Performance Classes 4.5.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
- editing 4.9
- ORA$QOS_CDB_PLAN 5.1.3
- used by Oracle Database QoS Management 1.4.1.2
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.3
- types of 1.5.2
- usage 1.5.2
- waits 1.5
- wait times 1.5.2
resource types 2.3.1
- bottlenecked 4.7.4
- CPU 2.3.2
- Global Cache 2.3.3
- I/O 2.3.4
- Other 2.3.5
- qosmserver 5.1.9
- viewing wait times 4.3.1
Resource Use vs. Wait Time chart 4.3.4
response time 1.3.6.1
response times
- average per request 2.1.4
- definition 1.5
- minimum achievable 2.5
RMI port conflict 5.1.9
role separation
- and Oracle ASM
run-time connection load balancing 2.1.3
run-time connection load balancing goal 1.3.1.3

S

scheduling
- active performance policy 4.6.4.2
scripting 4.6.4.3
SERVER_NAMES attribute 3.1.2
server pool directive overrides 2.5
- configuring 4.4.3, 4.6.7
- specifying 4.6.2
- valid values 4.6.7
server pools 1.3.1.1, 1.3.2, 1.3.3, 1.4.1.3
- accessing 3.1, 5.1.4
- adding to a Policy Set 4.4.2
- adjusting size of 1.4.1
- and multiple databases 2.1.2
- and recommendations 1.3.8.2.3
- 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.4.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.6.7
- list of 4.3.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, 5.1.5
- minimum size 1.3.8.2, 1.3.8.2.1, 2.5, 3.1
- minimum size of one 2.1.1
- modifying settings 4.4.3
- modifying using Oracle Enterprise Manager 4.4.3
- privileges 3.1.2
- removing servers from 2.1.1
- selecting for management 4.4.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.4.1
servers
- added to wrong server pool 5.1.8
- hosting the Oracle Database QoS Management server 2.6
SERVICE_NAME 1.3.5.3
SERVICE_TIME 1.3.1.3
service-level agreements (SLAs) 1.3.8.6, 2.4.3, 2.5, 2.6, 4.6.1
service levels 1.3.6.1
services 1.3.1
- adding to the Policy Set 4.4.4, 4.4.5
- and Oracle Clusterware 2.1.3
- and work requests 1.4.1.1
- configuring load balancing goals 2.1.3
- creating 3.1.3.2
- 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 1.4.1.1
- SINGLETON 2.1.2, 2.1.3, 5.1.5
- specifying multiple 4.5.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
Set Policy 4.6.4.2
singleton databases 2.1.2
SINGLETON services 2.1.3, 5.1.5
Situation Analysis 4.3.6
SLA
- See: service-level agreements
slice 1.3.1.2
SQL performance issues 2.3.5
SRVCTL 2.1.3, 4.4.2, 4.8, 5.1.4, 5.1.9
startup order for databases
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
support for Administrator-Managed databases , 1.3.4
system parameters 1.4.2
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
USERENV namespace 2.2
USERNAME 1.3.5.3
user name 2.2
users
- APPQOSSYS 5.1.2
- creating administrators 4.8
- default for QoSAdmin 4.8.1

V

viewing
- current server pool settings 4.4.1
- latest analysis results 4.3.5
- performance metrics 4.7.1, 4.7.2
- recommendation details 4.3.6
- recommendations 4.3.5
- resource wait times 4.7.4
violations 3.1.5
- and CPU_COUNT 3.1.3.1
- configuration 2.1, 2.1.2, 4.4.1
- for Performance Objectives 2.6
- logs 2.6
- resource plan not enabled 5.1.3
- viewing 4.3.1

W

wait times 1.5, 2.3.5
- for resources 4.7.4
- viewing 4.3.1
wizards
- Create Policy Set 3.1.5.2
- Edit Policy Set 4.4, 4.4.1, 4.5.1, 4.5.2, 4.5.3, 4.5.4
workload rank
- and database startup order 1.3.6.4
workloads 1.3.2, 1.3.8
- See also: Performance Classes
- and creating new Performance Classes 2.1.4
- and GV$ view requests 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 work subsets 2.1.4
- managing 2.2
- monitoring 1.3.1.3
- OLTP 2.1.4
- scaling 1.3.3
- separating 1.3.1
- supported response times 2.1.4
- supported types 1.4, 1.5.3, 2.1.4
- surges 2.4.2, 2.5, 2.6
- tuning goals 1.3.3
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.5.1
- definition 1.4
- managing separately 1.3.5.4
- metrics 1.5