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