Go to main content
36/36
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
1
ACL attributes
1
ACTION
1
,
2
activating
Performance Policies
1
active resource plan
1
adding
classifiers to a Performance Class
1
servers to server pools
1
services to the Policy Set
1
,
2
administrator-managed databases
support for
1
,
2
administrators
cluster
1
,
2
,
3
creating for Oracle Database QoS Management
1
creating the QoSAdmin user
1
database
1
initial configuration tasks
1
Oracle Database QoS Management
1
alerts
in Oracle Enterprise Manager
1
,
2
alternative recommendations
1
,
2
application contexts
1
applications
classifying work requests
1
definition
1
parameters used by classifiers
1
resource requirements
1
supported connections
1
APPQOS_PLAN
editing
1
APPQOSSYS user
1
,
2
audit log
1
authorized actions
1
,
2
,
3
Automatic Database Diagnostic Monitor (ADDM)
1
Automatic Workload Repository (AWR)
1
average response times
and Performance Classes
1
and Performance Objectives
1
,
2
definition
1
,
2
B
batch jobs
1
bequeath connections
1
bottlenecks
and Performance Classes
1
,
2
and Performance Objectives
1
and recommendations
1
CPU resource
1
for Performance Classes
1
Global Cache resource
1
I/O resource
1
locating using metrics
1
Other resource
1
resolving
1
business objectives
1
C
calendars
1
candidate server lists
1
CDB
1
,
2
CGroups
1
CHM
1
classification rules
defaults
1
classifiers
adding
1
and multiple services
1
,
2
and Performance Classes
1
,
2
and service names
1
and session attributes
1
and tags
1
creating
1
default_pc
1
deleting
1
evaluation order
1
for the default Performance Class
1
modifying
1
multiple attributes
1
order of evaluation
1
session attributes
1
specifying evaluation order
1
,
2
clients
Java Database Connectivity (JDBC) clients
1
name of program
1
Oracle Call Interface (OCI)
1
supported connections
1
tracking across database sessions
1
cluster administrator
1
,
2
,
3
,
4
configuration recommendations
1
configuration violations
1
,
2
configuring
load balancing goals
1
Oracle Grid Infrastructure for a cluster
1
Oracle RAC databases
1
Performance Objectives
1
server pool directive overrides
1
,
2
,
3
server pools
1
connecting to a database
1
connection load balancing
1
connection pools
1
connections
bequeath
1
load balancing
1
load balancing at run time
1
to databases
1
consumer groups
recommendations
1
,
2
container database
1
container database (CDB)
1
control groups
1
copying Performance Policies
1
CPU_COUNT
and multiple databases
1
,
2
default value
1
,
2
CPU partition
1
CPU resource bottlenecks
resolving
1
CPU shares
1
Create Policy Set wizard
1
creating
initial Policy Set
1
Oracle Database QoS Management administrator user
1
Performance Classes
1
Performance Policies
1
QoSAdmin user
1
server pools
1
,
2
services
1
CRSCTL
1
D
Dashboard
accessing
1
analysis result for recommendations
1
and recommendations
1
and resource bottlenecks
1
and workload surges
1
description of General section
1
implementing recommendations
1
logging in
1
main sections
1
Performance Overview
1
,
2
Performance Satisfaction Metric chart
1
QoS Status
1
recommendations not generated
1
Recommendations section
1
Resource Use vs. Wait Time chart
1
Resource Wait Times Breakdown
1
,
2
Situation Analysis
1
viewing recommendation details
1
viewing recommendations
1
database
startup order determined by rank
1
Database Configuration Assistant (DBCA)
1
database connections
1
database parameters
1
Database Resource Manager
See:
Oracle Database Resource Manager
databases
adding services
1
,
2
and CPU_COUNT
1
,
2
compliant
1
connecting with a service
1
connections
1
default service
1
enabling Oracle Database QoS Management
1
Oracle RAC One Node
1
policy-managed
1
,
2
,
3
services
1
sharing a server pool
1
singleton
1
startup order
1
upgrading
1
database services
See:
services
database sessions
tracking client requests
1
defaults
and classifiers
1
and CPU_COUNT
1
,
2
database services
1
namespace
1
password for QoSAdmin user
1
Performance Policy
1
,
2
Policy Set
1
,
2
QoSAdmin password
1
deleting
classifiers for a Performance Class
1
Performance Classes
1
Performance Policies
1
demand
changing levels of
1
surges
1
,
2
,
3
,
4
disabling
Oracle Database QoS Management for a cluster
1
E
Edit Policy Set wizard
1
,
2
,
3
,
4
,
5
,
6
enabling
Oracle Database QoS Management
1
Oracle Database QoS Management for a cluster
1
,
2
,
3
,
4
Oracle Database QoS Management for a database
1
tracing
1
Enterprise Manager
integration with Oracle Database QoS Management server
1
evaluating classifiers
1
evaluation order of classifiers
1
F
FAST_START_MTTR_TARGET
1
fast application notification (FAN)
1
floaters
1
Free pool
1
,
2
G
Global Cache resource bottlenecks
resolving
1
goals
and services
1
LONG
1
SEVICE_TIME
1
SHORT
1
THROUGHPUT
1
Grid Infrastructure Management Repository
1
GV$ view queries
1
H
headroom
maximizing
1
high availability
1
I
I/O resource bottlenecks
resolving
1
implementing
alternative recommendations
1
automatic actions
1
recommendations
1
initialization parameters
CPU_COUNT
1
,
2
initial Policy Set
1
instance caging
1
,
2
IP addresses
IPv6 support
1
J
Java Database Connectivity
clients
1
JDBC
See:
Java Database Connectivity
L
LMS processes
1
load balancing
configuring goals for a service
1
connections
1
run-time connection
1
load balancing advisory
data
1
goal
1
,
2
log files
1
M
maintenance windows
1
managed server pools
and Oracle RAC database instances
1
managing
server pools
1
,
2
users
1
MCB
See:
Multi-CPU Binding
measure-only
Performance Classes
1
,
2
,
3
Performance Policies
1
measure-only mode
1
,
2
MemoryGuard
1
,
2
memory pressure
1
metrics
collecting
1
for performance
1
for Performance Classes
1
for resources
1
not displayed
1
performance satisfaction
1
minimum response times
1
minimum size of server pools
1
modifying
classifiers for a Performance Class
1
Performance Classes
1
Performance Policies
1
server pool settings
1
MODULE
1
,
2
Multi-CPU Binding
1
multitenant database
1
multitenant databases
1
multi-tier environments
1
N
namespaces
default
1
O
OC4J container
locating
1
OCI
See:
Oracle Call Interface
OCIAttrSet function
1
ODP.NET
1
OLTP workloads
1
open workloads
1
ORA$QOS_CDB_PLAN
editing
1
ORA$QOS_PLAN
editing
1
Oracle ASM
access control
1
patching
1
role separation
1
Oracle Call Interface
clients
1
Oracle Cluster Health Monitor
1
Oracle Clusterware Repository
1
,
2
Oracle Database QoS Management
administrator
1
,
2
changing active Performance Policy
1
,
2
Dashboard
1
See also:
Dashboard
Dashboard sections
1
disabling for a cluster
1
enabling for a cluster
1
,
2
,
3
,
4
enabling for a database
1
log files
1
selecting server pools
1
server hosting the OC4J container
1
status
1
trace files
1
troubleshooting
1
using the Dashboard
1
viewing cluster management status
1
viewing current status
1
Oracle Database QoS Management administrator
creating
1
default password
1
Oracle Database Resource Manager
enabling
1
Oracle Enterprise Manager alerts
1
Oracle Enterprise Manager Dashboard
1
See also:
Dashboard
Oracle RAC databases
creating
1
supported releases
1
Oracle RAC high availability framework
1
Oracle RAC One Node databases
1
Oracle Real Application Clusters (Oracle RAC)
and Oracle Database QoS Management
1
Oracle Wallet
1
overloaded systems
1
overrides
See:
server pool directive overrides
P
parallel queries
1
patching
Oracle ASM
1
PDB
1
PDB shares
1
performance class
ranks
1
Performance Classes
adding classifiers
1
adding services
1
,
2
and alerts
1
and classifiers
1
and homogenous requests
1
and services
1
changing the rank
1
classifier ordering
1
classifiers
1
configuring Performance Objectives
1
creating
1
creating classifiers
1
default
1
default names
1
deleting
1
deleting classifiers
1
evaluating classifiers
1
improvements in performance
1
Incomplete data
1
list of
1
managing work requests separately
1
maximum
1
measure-only
1
,
2
,
3
metrics
1
metrics missing
1
modifying
1
modifying classifiers
1
multiple classifiers
1
No demand
1
Nonconforming data
1
projected impact of recommendations
1
ranks
1
relation to Performance Objectives
1
renaming
1
satisfying Performance Objectives
1
setting evaluation order of classifiers
1
specifying evaluation order of classifiers
1
specifying ranks
1
suggested by application developer
1
unable to collect metrics
1
used in Performance Policies
1
viewing performance metrics
1
,
2
,
3
viewing resource wait times
1
wait times for resources
1
performance metrics
1
performance objectives
importance
1
supported types
1
Performance Objectives
and services
1
configuring
1
definition
1
managing
1
ranks
1
,
2
relation to Performance Classes
1
specifying
1
specifying values
1
Performance Policies
activating
1
and server pools
1
changing active
1
,
2
copying
1
creating
1
creating additional
1
default
1
Default policy
1
definition
1
deleting
1
measure-only
1
modifying
1
ranking Performance Classes
1
refining with Performance Classes
1
scheduling the active policy
1
server pool directive overrides
1
performance projections
1
Performance Satisfaction Metric (PSM)
1
,
2
,
3
,
5
performance tuning
1
pluggable database (PDB)
1
pluggable databases
monitoring
1
Policy and Performance Management engine
1
policy changes
logs
1
policy-managed databases
1
,
2
Policy Set
active policy
1
adding server pools
1
administrating
1
creating a new Policy Set
1
current policy
1
default
1
initial
1
modifying
1
Policy Sets
contents
1
creating
1
default
1
,
2
default settings
1
PROGRAM
1
,
2
Q
qosadmin
1
QoS administrator
initial configuration tasks
1
QoSAdmin user
default password
1
,
2
qosctl
1
QOSCTL utility
syntax
1
qosmserver
default port
1
R
ranking Performance Objectives
1
ranks
and database startup order
1
and Performance Classes
1
,
2
Performance Classes
1
recommendations
alternatives
1
,
2
analysis results
1
automatically implemented
1
choosing a different action
1
consumer group mappings
1
,
2
generating
1
implementing
1
,
2
,
3
implementing alternative recommendations
1
interval
1
iterations
1
negative impacts
1
not being displayed
1
not generated
1
reallocating servers
1
section of the Dashboard
1
Situation Analysis
1
viewing
1
,
2
viewing details
1
Recommended Actions page
1
removing servers from a server pool
1
renaming
Performance Classes
1
requirements
system
1
,
2
resolving
CPU resource bottlenecks
1
Global Cache resource bottlenecks
1
I/O resource bottlenecks
1
Other resource bottlenecks
1
resource bottlenecks
resolving
1
Resource Manager
See:
Oracle Database Resource Manager
resource plans
APPQOS_PLAN
1
,
2
editing
1
ORA$QOS_CDB_PLAN
1
used by Oracle Database QoS Management
1
resources
allocating
1
bottlenecks
and recommendations
1
increasing CPU access
1
resolving bottlenecks
1
starved
1
types of
1
usage
1
waits
1
wait times
1
resource types
bottlenecked
1
CPU
1
Global Cache
1
I/O
1
Other
1
qosmserver
1
viewing wait times
1
Resource Use vs. Wait Time chart
1
response time
1
response times
average per request
1
definition
1
minimum achievable
1
RMI port conflict
1
role separation
and Oracle ASM
1
run-time connection load balancing
1
run-time connection load balancing goal
1
S
satrtup order for databases
1
scheduling
active performance policy
1
scripting
1
SERVER_NAMES attribute
1
server pool directive overrides
configuring
1
,
2
specifying
1
valid values
1
server pools
accessing
1
,
2
adding to a Policy Set
1
adjusting size of
1
and multiple databases
1
and recommendations
1
and services
1
attributes
1
candidate server lists
1
,
2
configuring
1
constraints
1
creating
1
,
2
directive overrides
1
execute permission
1
Free pool
1
,
2
increasing minimum pool size
1
list of
1
managed
1
,
2
marked as managed
1
maximum size of one
1
,
2
,
4
minimum size
1
,
2
,
3
,
4
minimum size of one
1
modifying settings
1
modifying using Oracle Enterprise Manager
1
privileges
1
removing servers from
1
selecting for management
1
SERVER_NAMES attribute
1
servers not added
1
unmanageable
1
unmanaged
1
using multiple server pools
1
viewing current settings
1
servers
added to wrong server pool
1
hosting the Oracle Database QoS Management server
1
SERVICE_NAME
1
SERVICE_TIME
1
service-level agreements (SLAs)
1
,
2
,
3
,
5
,
6
service levels
1
services
adding to the Policy Set
1
,
2
and Oracle Clusterware
1
and work requests
1
configuring load balancing goals
1
creating
1
default database service
1
defaults
Performance Classes
1
discovered automatically
1
for database connections
1
load balancing
1
names
1
singleton
1
SINGLETON
1
,
2
,
3
specifying multiple
1
transactional shut down
1
UNIFORM
1
,
2
used by workloads
1
session attributes
ACTION
1
and classifiers
1
MODULE
1
program
1
user name
1
Set Policy
1
singleton databases
1
SINGLETON services
1
,
2
Situation Analysis
1
SLA
See:
service-level agreements
slice
1
SQL performance issues
1
SRVCTL
1
,
2
,
3
,
4
,
5
storage interconnect
1
supported
connection types
1
Oracle RAC database releases
1
response times
1
workloads
1
,
2
,
3
support for Administrator-Managed databases
1
,
2
system parameters
1
system performance
evaluating
1
,
2
system requirements
1
,
2
T
tagging
1
tags
and classifiers
1
for work requests
1
trace files
1
tracing
enabling
1
troubleshooting
enabling Oracle Database QoS Management for a cluster
1
enabling Oracle Database QoS Management for a database
1
U
UNIFORM services
1
USERENV namespace
1
USERNAME
1
user name
1
users
APPQOSSYS
1
creating administrators
1
default for QoSAdmin
1
V
viewing
current server pool settings
1
latest analysis results
1
performance metrics
1
,
2
recommendation details
1
recommendations
1
resource wait times
1
violations
and CPU_COUNT
1
configuration
1
,
2
,
3
for Performance Objectives
1
logs
1
resource plan not enabled
1
viewing
1
W
wait times
for resources
1
viewing
1
wizards
Create Policy Set
1
Edit Policy Set
1
,
2
,
3
,
4
,
5
,
6
workload rank
and database startup order
1
workloads
and creating new Performance Classes
1
and GV$ view requests
1
and parallel queries
1
and server pools
1
calls and Performance Classes
1
consolidating
1
database connections
1
different resource requirements for work subsets
1
managing
1
monitoring
1
OLTP
1
scaling
1
separating
1
supported response times
1
supported types
1
,
2
,
3
surges
1
,
2
,
3
tuning goals
1
work requests
and services
1
and tags
1
creating classifiers
1
definition
1
managing separately
1
metrics
1
Scripting on this page enhances content navigation, but does not change the content in any way.