Index
A
- ACL attributes 10.1.4
 - ACTION 6.3.5.3, 7.2
 - activating 
- Performance Policies 9.6.4.2
 
 - active resource plan 10.1.3
 - adding
 - administrator-managed databases 
- support for 6.3.4
 
 - administrators
 - alerts
 - alternative recommendations 6.3.8.3, 9.3.6
 - application contexts 7.2
 - applications
 - APPQOS_PLAN 8.1.5.1, 10.1.3
- editing 9.9
 
 - APPQOSSYS user 8.1.5.1, 10.1.2
 - audit log 7.6
 - authorized actions 9.6.1, 9.6.6
 - automated risk identification 1.2.1
 - Automatic Database Diagnostic Monitor (ADDM) 7.3.5
 - automatic diagnostic collections 15.1
 - Automatic Diagnostic Repository
 - Automatic Diagnostic Repository (ADR) 12.1, 12.3
 - automatic purging 19.3.1
 - automatic restart 2.1
 - Automatic Workload Repository (AWR) 7.3.5
 - AUTORUN_FLAGS
 - AUTORUN_SCHEDULE
 - availability issues
 - average response times
 
C
- calendars 6.3.2
 - candidate server lists 8.1.2
 - capture debug output 2.11.2
 - CA-signed certificate 19.7.3
 - CDB 6.3.8.2.4, 6.4.1.2
 - certificates 22.1
 - CGroups 8.1.6
 - CHACTL 3.2, 3.6
 - chmod 2.11.4
 - classification rules 
- defaults 6.3.5.2
 
 - classifiers 6.3.5, 6.3.5.2, 7.2
- adding 9.5.4.1
 - and multiple services 7.2, 9.5.1
 - and Performance Classes 7.2, 9.5.1
 - and service names 6.3.5.3
 - and session attributes 7.2
 - and tags 7.2
 - creating 9.5.1
 - default_pc 9.5.5
 - deleting 9.5.4.3
 - evaluation order 10.1.6
 - for the default Performance Class 9.5.5
 - modifying 9.5.4.2
 - multiple attributes 7.2
 - order of evaluation 7.2
 - session attributes 7.2
 - specifying evaluation order 9.4.1, 9.5.5
 
 - clients
 - cluster_database 12.1
 - cluster administrator 8.1.2, 8.1.4, 9.8, 10.1.4
 - Cluster Health Monitor 4
 - Cluster Health Monitor
 - cluster or host view 20.2
 - cluster resource activity log 5.3,
 - cluster resource failures 
- monitoring 5.3
 
 - collection period 18.1
 - command interfaces 14.7
 - configuration recommendations 7.3
 - configuration violations 7.1, 7.1.2
 - configuring
 - connecting to a database 7.1.3
 - connection load balancing 7.1.3
 - connection pools 7.1.3
 - connections
 - consumer groups 6.3.1.1, 6.4.1
 - container database 6.3.8.2.4
 - container database (CDB) 7.1.2
 - control groups 8.1.6
 - copying Performance Policies 9.6.3
 - CPU_COUNT 6.3.1.2, 10.1.5
 - CPU partition 6.3.1.2
 - CPU resource bottlenecks 
- resolving 7.3.2
 
 - CPUS
 - CPU shares 6.3.8.2.4
 - create incident tickets 2.8.8.1
 - Create Policy Set wizard 8.1.5.2
 - creating
 - CRSCTL 10.1.4
 - csv format file output
 - custom application integration 2.10.3
 
D
- daemon
 - daemon mode operation 2.1
 - Dashboard 
- accessing 9.3.1
 - analysis result for recommendations 9.3.5
 - and recommendations 6.3.8.1
 - and resource bottlenecks 7.3.1
 - and workload surges 7.6
 - description of General section 9.3.1
 - implementing recommendations 9.3.7
 - logging in 8.1.4
 - main sections 9.3.1
 - Performance Overview 9.3.1, 9.3.4
 - Performance Satisfaction Metric chart 9.3.4
 - QoS Status 9.3.1
 - recommendations not generated 10.1.7
 - Recommendations section 9.3.1
 - Resource Use vs. Wait Time chart 9.3.4
 - Resource Wait Times Breakdown 9.3.1, 9.7.4
 - Situation Analysis 9.3.6
 - viewing recommendation details 9.3.6
 - viewing recommendations 9.3.5
 
 - database 
- startup order determined by rank 6.3.6.4
 
 - database alert logs 12.3
 - Database Configuration Assistant (DBCA) 8.1.2
 - database connections 6.3.1.3
 - database parameters 6.4.2
 - Database Resource Manager 
- See: Oracle Database Resource Manager
 
 - databases 
- adding services 9.4.4, 9.4.5
 - and CPU_COUNT 7.1.2, 8.1.3.1
 - compliant 10.1.2
 - connecting with a service 7.1.3
 - connections 7.1.4
 - default service 7.1.3
 - enabling Oracle Database QoS Management 10.1.2
 - Oracle RAC One Node 7.1.2
 - policy-managed 6.3.4, 7.1.2, 10.1.2
 - services 7.1.2
 - sharing a server pool 7.1.2
 - singleton 7.1.2
 - upgrading 6.3.4
 
 - database services 
- See: services
 
 - database sessions 
- tracking client requests 7.2
 
 - data redaction 14.8
 - defaults
 - deleting
 - demand
 - detailed view 20.3
 - DEVICES
 - diff report 2.4.4
 - disabling 
- Oracle Database QoS Management for a cluster 9.3.3
 
 
E
- edit incident tickets 2.8.8.2
 - Edit Policy Set wizard 9.4, 9.4.1, 9.5.1, 9.5.2, 9.5.3, 9.5.4
 - Elasticsearch 2.10.2
 - email notification 2.2, 15.2
 - enabling
 - Enterprise Manager 
- integration with Oracle Database QoS Management server 6.3.7
 
 - evaluating classifiers 9.5.1
 - evaluation order of classifiers 9.5.5
 - Expect utility 2.4.1, 22.1
 
I
- I/O resource bottlenecks 
- resolving 7.3.4
 
 - implementing
 - import CA certificates 20.7
 - init.tfa 22.2
 - initialization parameters
 - initial Policy Set 8.1.5.2
 - install
 - instance caging 6.3.1.2, 8.1.6
 - integration 2.10
 - Interconnects page 
- monitoring Oracle Clusterware with Oracle Enterprise Manager 5
 
 - investigate logs 16.3
 - IPS packages 18.9
 
M
- maintenance windows 6.3.2
 - manage diagnostic collections 19.4.2
 - manage directories 19.4.1
 - managed server pools 
- and Oracle RAC database instances 7.1.2
 
 - managing
 - manual purging 19.3.2
 - Maximum Availability Architecture (MAA) Scorecard 2.2.2
 - MCB 
- See: Multi-CPU Binding
 
 - measure-only 9.6.1
 - measure-only mode 7.5
 - Memory Guard 1.2.5, 11
- log file 11.2
 
 - merged files 20.6
 - metrics 6.5
 - metrics view 20.2
 - minimum response times 7.5
 - minimum size of server pools 7.5
 - modifying
 - MODULE 6.3.5.3, 7.2
 - Multi-CPU Binding 8.1.6
 - multitenant database 6.4.1.2
 - multitenant databases 7.1.2
 - multi-tier environments 7.2
 
O
- OC4J container 
- locating 8.1.4
 
 - OCHAD daemon 3.1
 - OCI 
- See: Oracle Call Interface
 
 - OCIAttrSet function 7.2
 - OCLUMON
 - ODP.NET 6.3.5.3
 - OLTP workloads 7.1.4
 - on-demand diagnostic collection 16.1
 - on-demand mode 2.4.1
 - openssl 19.7.3
 - open workloads 6.1
 - ORA$QOS_CDB_PLAN 10.1.3
- editing 9.9
 
 - ORA$QOS_PLAN 
- editing 9.9
 
 - Oracle Call Interface 6.3.1.3, 6.3.5.3
- clients 7.1.4
 
 - Oracle Cluster Health Advisor 1.2.4, 3
 - Oracle Cluster Health Advisor daemon 3.1
 - Oracle Cluster Health Advisor model 3.5
 - Oracle Clusterware
 - Oracle Clusterware Repository 8.1.5.1, 9.8
 - Oracle Database QoS Management 
- See also: Dashboard
 
- administrator 8.1, 8.1.4
 - changing active Performance Policy 9.6.4.1, 9.6.4.3
 - Dashboard  9.3.1
- See also: Dashboard
 
 - Dashboard sections 9.3.1
 - demand 
- surges 1.2.7
 
 - disabling for a cluster 9.3.3
 - enabling for a cluster 7.4.3, 8.1.5, 8.1.5.3, 9.3.2
 - enabling for a database 8.1.5
 - log files 10.2
 - open workloads 1.2.7
 - selecting server pools 9.4.1
 - server hosting the OC4J container 8.1.4
 - status 9.3.1
 - trace files 10.2
 - using the Dashboard 9.3.1
 - viewing cluster management status 9.1.2
 - viewing current status 8.1.5.3
 - work requests 1.2.7
 
 - Oracle Database QoS Management administrator 9.3.1
 - Oracle Database Resource Manager 6.3.1.1, 6.4.1, 9.9
- enabling 10.1.3
 
 - Oracle Enterprise Manager 2.10.1
- using the Interconnects page to monitor Oracle Clusterware 5
 
 - Oracle Enterprise Manager alerts 7.6
 - Oracle Enterprise Manager Dashboard 6.3.8.1
- See also: Dashboard
 
 - Oracle Health Check Collections Manager 2.8
 - Oracle ORAchk and EXAchk command-line options 2.7, 
- daemon options
 - file attribute changes 2.7.1
 - generic commands
 - managing the report output
 - scope of checks
 - uploading results to database
 
 - Oracle ORAchk and Oracle EXAchk 1.2.1, 2, 2.1
 - Oracle ORAchk and Oracle EXAchk prerequisites
 - Oracle RAC 11.4
 - Oracle RAC databases
 - Oracle RAC high availability framework 7.1.3
 - Oracle RAC One Node 11.4
 - Oracle RAC One Node database 11.3, 12.2
 - Oracle RAC One Node databases 7.1.2
 - Oracle Real Application Clusters (Oracle RAC) 3, 6.4, 11
- and Oracle Database QoS Management 6.4.1
 
 - Oracle Trace File Analyzer 1.2.3, 13
 - Oracle Trace File Analyzer log analyzer utility
 - Oracle Trace File Analyzer service 20.1
 - Oracle Wallet 8.1.5.1
 - OSWatcher 22.8
 - oswbb 22.10
 - overloaded systems 6.3.8.2.3
 - overrides 
- See: server pool directive overrides
 
 
P
- parallel queries 7.1.4
 - PDB 6.4.1.2
 - PDB shares 6.4.1.2
 - performance class 
- ranks 6.3.6.4
 
 - Performance Classes 6.3.2, 6.3.5, 6.3.5.3, 6.5.3, 7.6, 9.6.1
- adding classifiers 9.5.4.1
 - adding services 9.4.4, 9.4.5
 - and alerts 7.6
 - and classifiers 7.2
 - and homogenous requests 7.1.4
 - and services 6.3.5.2
 - changing the rank 9.6.2
 - classifier ordering 10.1.6
 - classifiers 7.2
 - configuring Performance Objectives 9.3.4
 - creating 9.5.1
 - creating classifiers 9.5.1
 - default 9.5.5
 - default names 6.3.2
 - deleting 9.5.2
 - deleting classifiers 9.5.4.3
 - evaluating classifiers 9.5.1
 - improvements in performance 6.3.8.3
 - Incomplete data 10.1.6
 - list of 9.3.1
 - managing work requests separately 6.3.5.4
 - maximum 7.2
 - measure-only 6.3.6.1, 9.3.4
 - metrics 9.3.1
 - metrics missing 10.1.6
 - modifying 9.5.4
 - modifying classifiers 9.5.4.2
 - multiple classifiers 9.5.1
 - No demand 10.1.6
 - Nonconforming data 10.1.6
 - projected impact of recommendations 6.3.7
 - ranks 6.3.6.3
 - relation to Performance Objectives 6.3.6.1
 - renaming 9.5.3
 - satisfying Performance Objectives 6.3.7
 - setting evaluation order of classifiers 9.4.1
 - specifying evaluation order of classifiers 9.5.5
 - specifying ranks 9.6.1
 - suggested by application developer 6.3.5.4
 - unable to collect metrics 10.1.5
 - used in Performance Policies 7.5
 - viewing performance metrics 9.3.4, 9.7.1, 9.7.2
 - viewing resource wait times 9.3.1
 - wait times for resources 9.7.4
 
 - performance issues
 - performance metrics 6.5.1
 - performance objectives
 - Performance Objectives 6.3.2, 6.5.3
 - Performance Policies 6.3.2, 6.3.6.1, 6.3.8
- activating 9.6.4.2
 - and server pools 7.1.1
 - changing active 9.6.4.1, 9.6.4.3
 - copying 9.6.3
 - creating 9.6.1
 - creating additional 7.5
 - default 7.5
 - Default policy 9.4.1
 - definition 6.3.6
 - deleting 9.6.5
 - measure-only 7.5
 - modifying 9.6.2
 - ranking Performance Classes 6.3.6.3
 - refining with Performance Classes 7.5
 - scheduling the active policy 9.6.4.2
 - server pool directive overrides 6.3.6.2
 
 - performance projections 7.6
 - Performance Satisfaction Metric (PSM) 6.5.3, 7.6, 9.3.4, 9.6.1
 - performance tuning 7.3.5
 - Perl 22.3
 - pluggable database (PDB) 7.1.2
 - pluggable databases 
- monitoring 6.3.8.2.4
 
 - Policy and Performance Management engine 6.3.7
 - policy changes 
- logs 7.6
 
 - policy-managed databases 7.1.2, 10.1.2
 - Policy Set
 - Policy Sets 6.3.2
 - privileged user 
- finding 2.8.7
 
 - proactive notification 1.2.1
 - PROCESSES
 - PROGRAM 6.3.5.3, 7.2
 - PROTOCOL ERRORS
 
R
- ranking Performance Objectives 7.5
 - ranks
 - recommendations 6.3.2, 6.3.7, 6.4.2, 7.6, 9.7.4
- alternatives 6.3.8.3, 9.3.6
 - analysis results 9.3.5
 - automatically implemented 9.6.6
 - choosing a different action 9.3.6
 - consumer group mappings 6.3.8.2, 6.3.8.2.1
 - contents 6.3.8.4
 - generating 6.3.8.3
 - implementing 6.3.8.1, 6.3.8.3, 9.3.7
 - implementing alternative recommendations 9.3.6
 - interval 9.3.4
 - iterations 6.3.8.6
 - negative impacts 6.3.8.3
 - not being displayed 9.3.7
 - not generated 10.1.7
 - reallocating servers 6.3.8.2.3
 - section of the Dashboard 9.3.1
 - Situation Analysis 9.3.6
 - viewing 9.3.1, 9.3.5
 - viewing details 9.3.6
 
 - Recommended Actions page 9.3.6
 - remote login 2.11.3
 - removing servers from a server pool 7.1.1
 - renaming 
- Performance Classes 9.5.3
 
 - report findings 2.2.2
 - report overview 2.2
 - repository 22.6
 - requirements
 - resolving
 - resource bottlenecks 
- resolving 7.3.5
 
 - Resource Manager 
- See: Oracle Database Resource Manager
 
 - resource plans
 - resources
 - resource types 7.3.1
 - Resource Use vs. Wait Time chart 9.3.4
 - response time 6.3.6.1
 - response times
 - RMI port conflict 10.1.9
 - run-time connection load balancing 7.1.3
 - run-time connection load balancing goal 6.3.1.3
 
S
- schedule email health check reports 1.2.1
 - scheduling 
- active performance policy 9.6.4.2
 
 - scripting 9.6.4.3
 - self-signed certificate 19.7.2
 - sensitivity 12.2
 - SERVER_NAMES attribute 8.1.2
 - server pool directive overrides 7.5
 - server pools 6.3.1.1, 6.3.2, 6.3.3, 6.4.1.3
- accessing 8.1, 10.1.4
 - adding to a Policy Set 9.4.2
 - adjusting size of 6.4.1
 - and multiple databases 7.1.2
 - and recommendations 6.3.8.2.3
 - and services 6.4.1.1
 - attributes 6.3.6.2
 - candidate server lists 6.3.4, 8.1.2
 - configuring 7.1.1
 - constraints 7.4.1
 - creating 8.1.2, 9.4.2
 - directive overrides 6.3.6.2
 - execute permission 10.1.4
 - Free pool 6.3.4, 8.1.2
 - increasing minimum pool size 9.6.7
 - list of 9.3.1
 - managed 7.1.1, 7.1.2
 - marked as managed 8.1.5.2
 - maximum size of one 7.1.2, 7.1.3, 10.1.5
 - minimum size 6.3.8.2, 6.3.8.2.1, 7.5, 8.1
 - minimum size of one 7.1.1
 - modifying settings 9.4.3
 - modifying using Oracle Enterprise Manager 9.4.3
 - privileges 8.1.2
 - removing servers from 7.1.1
 - selecting for management 9.4.1
 - SERVER_NAMES attribute 8.1.2
 - servers not added 10.1.8
 - unmanageable 10.1.5
 - unmanaged 7.1.1
 - using multiple server pools 6.3.3
 - viewing current settings 9.4.1
 
 - servers
 - SERVICE_NAME 6.3.5.3
 - SERVICE_TIME 6.3.1.3
 - service-level agreements (SLAs) 6.3.8.6, 7.4.3, 7.5, 7.6, 9.6.1
 - service levels 6.3.6.1
 - services 6.3.1
- adding to the Policy Set 9.4.4, 9.4.5
 - and Oracle Clusterware 7.1.3
 - and work requests 6.4.1.1
 - configuring load balancing goals 7.1.3
 - creating 8.1.3.2
 - default database service 7.1.3
 - defaults 
- Performance Classes 6.3.5.2
 
 - discovered automatically 7.4.3
 - for database connections 7.1.4
 - load balancing 7.1.3
 - names 7.2
 - singleton 6.4.1.1
 - SINGLETON 7.1.2, 7.1.3, 10.1.5
 - specifying multiple 9.5.1
 - transactional shut down 6.3.8.6
 - UNIFORM 7.1.2, 7.1.3
 - used by workloads 7.1.3
 
 - session attributes 7.2
 - Set Policy 9.6.4.2
 - silent mode operation
 - singleton databases 7.1.2
 - SINGLETON services 7.1.3, 10.1.5
 - Situation Analysis 9.3.6
 - skipped checks 2.11.5
 - SLA 
- See: service-level agreements
 
 - slice 6.3.1.2
 - sockets 22.4
 - SQL performance issues 7.3.5
 - SRVCTL 7.1.3, 9.4.2, 9.8, 10.1.4, 10.1.9
 - SSL certificates 22.4
 - SSL cipher suite 19.7.4
 - SSL protocols 19.7.1
 - storage interconnect 7.3.4
 - subsequent email 2.2.3
 - sudo 2.3.1
 - supported
 - supported environments 14.1
 - support for Administrator-Managed databases 6.3.4
 - SYSTEM
 - system and cluster summary 16.2
 - system parameters 6.4.2
 - system performance
 - system requirements 7.1, 7.3
 
T
- tabular format file output
 - tagging 6.3.5.3
 - tags 6.3.5, 7.2
 - TFACTL 
- commands 
- tfactl access
 - tfactl analyze
 - tfactl changes
 - tfactl collection
 - tfactl dbglevel 16.7.1
 - tfactl diagcollect
 - tfactl diagnosetfa
 - tfactl directory
 - tfactl events
 - tfactl host
 - tfactl ips
 - tfactl ips ADD
 - tfactl ips ADD FILE
 - tfactl ips ADD NEW INCIDENTS PACKAGE
 - tfactl ips COPY IN FILE
 - tfactl ips CREATE PACKAGE
 - tfactl ips DELETE PACKAGE
 - tfactl ips FINALIZE PACKAGE
 - tfactl ips GENERATE PACKAGE
 - tfactl ips GET MANIFEST FROM FILE
 - tfactl ips GET METADATA
 - tfactl ips GET REMOTE KEYS FILE
 - tfactl ips PACK
 - tfactl ips REMOVE
 - tfactl ips REMOVE FILE
 - tfactl ips SET CONFIGURATION
 - tfactl ips SHOW CONFIGURATION
 - tfactl ips SHOW FILES PACKAGE
 - tfactl ips SHOW INCIDENTS PACKAGE
 - tfactl ips SHOW PACKAGE
 - tfactl ips SHOW PROBLEMS
 - tfactl ips UNPACK FILE
 - tfactl ips UNPACK PACKAGE
 - tfactl ips USE REMOTE KEYS FILE
 - tfactl managelogs
 - tfactl print
 - tfactl purge
 - tfactl run
 - tfactl set
 - tfactl summary
 - tfactl toolstatus
 
 - Oracle Trace File Analyzer command-line utility
 
 - commands 
 - Time Machine software 22.12
 - timeouts 2.11.5
 - TLS protocols 19.7.1
 - tools bundle 16.4
 - TOP CONSUMERS
 - Trace File Analyzer 
- disk usage snapshots 21.2
 
 - trace files 10.2
 - trace logs 12.3
 - tracing 
- enabling 10.3
 
 - Troubleshoot
 - troubleshooting
 
U
W
- wait times 6.5, 7.3.5
 - wizards
 - workload rank 
- and database startup order 6.3.6.4
 
 - workloads 6.3.2, 6.3.8
- See also: Performance Classes
 
- and creating new Performance Classes 7.1.4
 - and GV$ view requests 7.1.4
 - and parallel queries 7.1.4
 - and server pools 6.3.3
 - calls and Performance Classes 7.2
 - consolidating 6.3.3
 - database connections 6.3.5.3
 - different resource requirements for work subsets 7.1.4
 - managing 7.2
 - monitoring 6.3.1.3
 - OLTP 7.1.4
 - scaling 6.3.3
 - separating 6.3.1
 - supported response times 7.1.4
 - supported types 6.4, 6.5.3, 7.1.4
 - surges 7.4.2, 7.5, 7.6
 - tuning goals 6.3.3
 
 - work requests 6.1, 6.3.5, 6.3.5.3