Skip Headers
Oracle® Database Quality of Service Management User's Guide
12c Release 1 (12.1)

E17619-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

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

A

access control
support for Oracle ASM, Preface
ACL attributes, 5.1.4
ACTION, 1.3.5.3, 2.2
activating
Performance Policies, 4.6.4
active resource plan, 5.1.3
adding
classifiers to a Performance Class, 4.5.4.1
Performance Classes, 2.5
servers to server pools, 5.1.8
services to the Policy Set, 4.4.4, 4.4.5
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
OC4J, 4.8.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
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.7.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
CHM, Preface
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
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.6.1
server pool directive overrides, 4.4.3, 4.6.2, 4.6.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 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
copying Performance Policies, 4.6.3
CPU partition, 1.3.1.2
CPU resource bottlenecks
resolving, 2.3.2
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
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.3
Situation Analysis, 4.3.6
viewing recommendation details, 4.3.6
viewing recommendations, 4.3.5
Database Configuration Assistant (DBCA), 3.1.2
database connections, 1.3.1.3
database parameters, 1.4.3
Database Resource Manager
See Oracle Database Resource Manager
database services
See services
database sessions
tracking client requests, 2.2
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
upgrading, 1.3.4
defaults
and classifiers, 4.5.5
and CPU_COUNT, 2.1.2, 3.1.3.1
database services, 2.1.3
namespace, 2.2
OC4J_PORT, 5.1.9
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
rank, 2.5
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.2

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

H

headroom, 4.3.4
maximizing, 2.5
high availability, 1.4.3

I

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

J

Java Database Connectivity, 1.3.1.3, 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
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
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
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.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-tier environments, 2.2

N

namespaces
default, 2.2

O

OC4J, 4.8
administrator, 4.8.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 ASM
access control, Preface
patching, Preface
role separation, Preface
Oracle Call Interface, 1.3.1.3, 1.3.5.3
clients, 2.1.4
Oracle Cluster Health Monitor, Preface
Oracle Clusterware Repository, 3.1.5.1, 4.8
Oracle Database QoS Management
administrator, 3.1, 3.1.4
changing active Performance Policy, 4.3.3
Dashboard
See also Dashboard
Dashboard sections, 4.3.1
disabling for a cluster, 4.3.2
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
enabling, 5.1.3
Oracle Enterprise Manager alerts, 2.6
Oracle Enterprise Manager Dashboard
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, Preface
Performance Classes, 1.3.2, 1.3.5, 1.3.5.3, 1.5.3, 2.6, 4.6.1
adding, 2.5
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
default rank, 2.5
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.3
performance metrics, 1.5.1
Performance Objectives, 1.3.2, 1.5.3
and services, 2.5
configuring, 4.3.4
definition, 1.3.6.1
importance, 1.3.6
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
supported types, 2.1.4
Performance Policies, 1.3.2, 1.3.6.1, 1.3.8
activating, 4.6.4
and server pools, 2.1.1
changing active, 4.3.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
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.3.4, 4.6.1
performance tuning, 2.3.5
Policy and Performance Management engine, 1.3.7
policy changes
logs, 2.6
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 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.3.1
default password, 3.1.4, 4.8.1
qosctl, 3.1.4
QOSCTL utility, 4.8
command reference, 4.8.1
syntax, 4.8.1

R

ranking Performance Objectives, 2.5
ranks
and Performance Classes, 1.3.6.3, 4.6.2
default, 2.5
Performance Classes, 4.6.1
recommendations, 1.3.2, 1.3.7, 1.4.3, 2.6, 4.7.3
alternative, 1.3.8.3
alternatives, 1.3.8.3, 4.3.6
analysis results, 4.3.5
choosing a different action, 4.3.6
consumer group mappings, 1.3.8.2, 1.3.8.2.1
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
used by Oracle Database QoS Management, 1.4.1.2
resource types, 2.3.1
bottlenecked, 4.7.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.3.1
Resource Use vs. Wait Time chart, 4.3.4
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
wait times, 1.5.2
waits, 1.5
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, Preface
run-time connection load balancing, 2.1.3
run-time connection load balancing goal, 1.3.1.3

S

server pool directive overrides, 2.5
configuring, 4.4.3, 4.6.6
specifying, 4.6.2
valid values, 4.6.6
server pools, 1.3.1.1, 1.3.2, 1.3.3, 2.1.1
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.6
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, 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
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.3
service-level agreements (SLAs), 1.3.8.6, 2.4.3, 2.5, 2.5, 2.6, 4.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, 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
sessions
rerouting, 1.4.2
Set Policy, 4.6.4
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
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.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.3
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.3
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
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.5.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 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
See Also Performance Classes
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