Index

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

A

• about 13
• Active Session History
  • about 8.1
  • ASH Analytics page 4.4
  • report
    • about 8.1
    • activity over time 8.3.6
    • load profile 8.3.2
    • running 8.2
    • top events 8.3.1
    • top SQL 8.3.3
    • using 8.3
  • sampled data 8.1
  • statistics 2.1.4
• active sessions 2.1.1
  • captured in Active Session History 2.1.4
• ADDM
  • See: Automatic Database Diagnostic Monitor
• Agent-to-Agent file transfer 10.3.2.4
• alerts
  • clearing 6.3
  • default 6
  • performance 6.1
  • responding to 6.2
• Applications
  • Automatic Workload Repository (AWR) 10.6
• ASH
  • See: Active Session History
• ASH Analytics 4.4
• Automatic Database Diagnostic Monitor
  • about 3.1
  • accessing results 7.3
  • analysis 3.1.1
  • configuring 3.2
  • findings
    • about 3.4
    • viewing 3.3
  • for a multitenant environment 3.1.4
  • for Oracle RAC 3.1.3
  • identifying high-load SQL 11.1
  • recommendations
    • actions 3.4
    • implementing 3.5
    • interpreting 3.4
    • rationales 3.4
    • types 3.1.2
  • report 3.3
  • reviewing results 3.3
  • running manually
    • analyzing current database performance 7.1
    • analyzing historical database performance 7.2
• Automatic Memory Management 10.3.1.1
• Automatic SQL Tuning
  • modifying task attributes 12.1.2
  • viewing recommendations 12.1.2
  • viewing results 12.1.2
• Automatic Storage Management 10.3.1.2
• Automatic Workload Repository
  • about 2.1
  • baselines 9.1
  • compare periods report
    • about 9
    • details 9.3.2
    • saving 9.2.1, 9.2.3
    • summary 9.3.1
    • supplemental information 9.3.3
    • using 9.3
    • using another baseline 9.2.1
  • snapshots 2.1
  • statistics collected by 2.1
  • using 3.2.3
• Automatic Workload Repository (AWR)
  • Applications) 10.6
  • Autonomous Data Warehouse (ADW) 10.5
• Autonomous Data Warehouse (ADW)
  • Automatic Workload Repository (AWR) 10.5
• average active sessions
  • about 4.1
• AWR
  • See: Automatic Workload Repository
• awrinfo.sql script 10.3.1.2
• AWR Warehouse
  • about 10
  • ASH Analytics page 10.2
  • AWR Report page 10.2
  • Compare Period ADDM page 10.2
  • Compare Periods Report page 10.2
  • credentials 10.3.2.1
  • ETL 10.1.2
  • extract errors 10.4
  • load errors 10.4
  • memory management 10.3.1.1
  • Performance Home page 10.2
  • set up 10.1
  • snapshot view access 10.1.1
  • source database 10.1.1
  • staging location 10.3.2.3
  • storage requirements 10.3.1.2
  • SYSAUX tablespace 10.3.1.2, 10.4
  • transfer errors 10.4
  • troubleshooting 10.4

B

• baselines
  • about 9.1
  • baseline template
    • about 9.1.1.1, 9.1.1.2
  • comparing 9.2.1, 9.2.2
  • creating 9.1.1
  • deleting 9.1.2
  • SQL plan 12.4

C

• CONTROL_MANAGEMENT_PACK_ASSESS parameter 2.2.1
  • and ADDM 3.2.1
  • and database operations 5.1.3
• CPU
  • I/O wait 4.3.1
  • load 4.3.1
  • performance problems 4.3.1
  • time 2.1.1
  • utilization, monitoring 4.3.1

D

• data access paths, optimizing 13
• Database Home page
  • accessing 1.4
• database operations
  • composite operations, defined 5.1.1
  • creating 5.2
  • enabling monitoring with initialization parameters 5.1.3
  • identifying an operation 5.1.4
  • monitoring 5.1
  • simple operations, defined 5.1.1
  • viewing on Monitored SQL Executions page 5.3
• database operations, monitoring
  • purpose 5.1.2
• database performance
  • alerts 6.1
  • automatic monitoring 3
  • comparing 9
  • current analysis 7.1
  • degradation over time 9
  • historical analysis 7.2
  • manual monitoring 7
  • overview 2
• Database Resource Manager
  • using 4.3.1
• database statistics
  • about 2.1
• database time
  • about 2.1.1
  • and ADDM findings 3.4
  • in calculating average active sessions 4.1
• database tuning
  • performance degradation over time 9
  • preparing the database 2.2.1
  • proactive tuning 2.2.2
  • reactive tuning 2.2.3
  • real-time performance problems 4
  • SQL tuning 2.2.4
  • tools 1.3
  • transient performance problems 8
  • using the Performance page 4
• Data Guard 10.3.1.3
• DBIO_EXPECTED parameter
  • setting 3.2.1, 3.2.2
• DBMS_ADVISOR package
  • configuring ADDM 3.2.2
  • setting DBIO_EXPECTED 3.2.2
• DBMS_SQL_MONITOR package 5.2
• DB time
  • See: database time
• disk
  • performance problems 4.3.3
  • utilization, monitoring 4.3.3

E

• ETL 10.1.2
• events 6
• execution plans
  • about 12
  • evolving 12.4.3
• extract errors, AWR Warehouse 10.4

H

• high-load SQL
  • about 11
  • identifying using ADDM 11.1
  • identifying using top SQL 11.3
  • statistics 2.1.5
  • tuning 12.1.1, 12.1.2
• host activity, monitoring 4.3
  • CPU 4.3.2
  • CPU utilization 4.3.1
  • disk utilization 4.3.3

I

• I/O wait times, monitoring 4.2.2
• incidents 6
• index
  • about 13
  • bitmap 13
  • B-tree 13
  • creating 13.1
  • functional 13
• indexes
  • creating 2.2.4
• initialization parameter 10.3.1.1
• In-Memory Column Store (IM column store)
• instance activity, monitoring 4.2
  • I/O wait times 4.2.2
  • parallel execution 4.2.3
  • services 4.2.4
  • throughput 4.2.1

J

• job_queue_processes parameter 10.3.1.6

L

• load errors, AWR Warehouse 10.4

M

• materialized view logs 13
  • creating 2.2.4, 13.1
• materialized views
  • creating 2.2.4, 13.1
• memory
  • performance problems 4.3.2
  • swap utilization 4.3.2
  • utilization, monitoring 4.3.2
• memory management, AWR Warehouse 10.3.1.1
• metrics 6.1, 9.1.3
• Monitored SQL Executions page 5.3
• monitoring
  • PL/SQL 4.1.3
  • resource consumption 4.1.4
  • session attributes 4.1.6
  • session identifiers 4.1.5
  • SQL 4.1.2

N

• Network Latency 10.3.2.4

O

• Oracle Diagnostics Pack 1.3
• Oracle performance method
  • about 2
  • pretuning tasks 2.2.1
  • proactive database tuning tasks 2.2.2
  • reactive database tuning tasks 2.2.3
  • SQL tuning tasks 2.2.4
  • using 2.2
• Oracle Tuning Pack 1.3

P

• parallel execution, monitoring 4.2.3
• parameters
  • CONTROL_MANAGEMENT_PACK_ASSESS 2.2.1, 3.2.1, 5.1.3
  • initialization 9.3.3
  • STATISTICS_LEVEL 3.2.1, 5.1.3
• Performance page
  • about 4
• performance problems
  • common 2.3
  • CPU 4.3.1
  • diagnosing 3.1
  • disk 4.3.3
  • memory 4.3.2
  • real-time 4
  • transient 8
• PL/SQL
  • monitoring 4.1.3
• problems, as a type of incident 6

R

• redo logs 10.3.1.4
• resource consumption 4.1.4
• RMAN 10.3.1.3

S

• services
  • about 4.2.4
  • monitoring 4.2.4
• session attributes 4.1.6
• session identifiers 4.1.5
• sessions
  • about 2.1.1
  • active 2.1.1, 2.1.4
  • average active 4.1
• snapshots
  • about 2.1
  • creating 3.2.3.1
  • default interval 3.2.3
  • modifying settings 3.2.3.2
  • viewing statistics 3.6
• snapshot upload, AWR Warehouse 10.1.2
• source database, AWR Warehouse 10.1.1
• spikes
  • determining cause of 4.4
• SQL
  • monitoring 4.1.2
• SQL Access Advisor
  • about 12, 13
  • filters 13.1.3
  • initial options 13.1.1, 13.2
  • recommendations
    • about 13
    • details 13.2.2
    • implementing 13.3
    • options 13.1.4
    • reviewing 13.2
    • SQL 13.2.3
    • summary 13.2.1
  • running 13.1
  • scheduling 13.1.5
  • task options 13.2.4
  • workload options 13.2.4
  • workload source 13.1.2
• SQL Performance Analyzer
  • about 2.3
• SQL plan baselines
  • about 12.4
  • capturing automatically 12.4.1
  • evolving 12.4.3
  • loading manually 12.4.2
• SQL plan management 12.4
• SQL Plan Management Evolve Advisor 12.4.3
• SQL profiles
  • deleting 12.3
  • disabling 12.3
  • enabling 12.3
• SQL Tuning Advisor
  • about 12
  • automated maintenance tasks 12.1.2
  • implementing recommendations 12.1.1
  • limited scope 12.1.1
  • using 12.1.1, 12.1.2
• SQL tuning sets
  • about 12.2
  • creating 12.2.1
  • load method 12.2.1.2
• stacked area charts
  • described 4.1
• statistics
  • Active Session History 2.1.4
  • baselines 9.1
  • database 2.1
  • database time 2.1.1, 3.4
  • default retention 3.2.3
  • gathering 2.1
  • high-load SQL 2.1.5
  • sampled data 8.1
  • session 2.1.3
  • system 2.1.3
  • wait events 2.1.2
• STATISTICS_LEVEL parameter
  • and ADDM 3.2.1
  • and database operations 5.1.3
• stats collection 10.3.1.5
• storage requirements, AWR Warehouse 10.3.1.2
• SYSAUX tablespace 10.3.1.2, 10.4

T

• throughput, monitoring 4.2.1
• Top Activity page
  • about 11.3
• top dimensions
  • monitoring 4.1.1
• top SQL
  • identifying high-load SQL 11.3
  • in Active Session History report 8.3.3
• transfer errors, AWR Warehouse 10.4
• troubleshooting, AWR Warehouse 10.4

U

• user activity, monitoring
  • about 4.1
  • top dimensions 4.1.1

W

• wait classes
  • grouped wait events 2.1.2
• wait events
  • statistics 2.1.2
• wait time 2.1.1