Index

A

actions
- about 4.1.5
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.6.2.4
alerts
- clearing 6.3
- default 6
- performance 6.1
- responding to 6.2
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 Oracle RAC 3.1.3
- identifying high-load SQL 11.1
- Real-Time 8.4
- 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.6.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.6.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
average active sessions
- about 4.1
AWR
- See: Automatic Workload Repository
awrinfo.sql script 10.6.1.2
AWR Warehouse
- about 10
- ASH Analytics page 10.4
- AWR Report page 10.4
- Compare Period ADDM page 10.4
- Compare Periods Report page 10.4
- credentials 10.6.2.1
- ETL 10.3
- extract errors 10.5
- load errors 10.5
- memory management 10.6.1.1
- Performance Home page 10.4
- set up 10.1
- snapshot view access 10.2
- source database 10.2
- staging location 10.6.2.3
- storage requirements 10.6.1.2
- SYSAUX tablespace 10.5, 10.6.1.2
- transfer errors 10.5
- troubleshooting 10.5

B

baselines
- about 9.1
- baseline template
  - about 9.1.1.1, 9.1.1.2
- comparing 9.2.1, 9.2.2
- computing threshold statistics for 9.1.3
- creating 9.1.1
- deleting 9.1.2
- SQL plan 12.4

C

clients
- about 4.1.6
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
customizing the Performance page 4.5

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.6.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

Emergency Performance page 8.4
ETL 10.3
events 6
execution plans
- about 12
- evolving 12.4.3
- viewing for a SQL statement 11.2.2.3
extract errors, AWR Warehouse 10.5

H

high-load SQL
- about 11
- identifying using ADDM 11.1
- identifying using top SQL 11.2
- identifying using top SQL by wait class 11.2.1
- statistics 2.1.5
- tuning 12.1.1, 12.1.2
- viewing details 11.2.2
- viewing execution plans 11.2.2.3
- viewing session activity 11.2.2.2
- viewing SQL text 11.2.2
- viewing statistics 11.2.2.1
- viewing tuning information 11.2.2.4
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.6.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.6.1.6

L

load errors, AWR Warehouse 10.5

M

materialized view logs
- about 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.6.1.1
metrics 6.1, 9.1.4
modules
- about 4.1.4
Monitored SQL Executions page 5.3

N

Network Latency 10.6.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
- customization 4.5
performance problems
- common 2.3
- CPU 4.3.1
- diagnosing 3.1
- diagnosing in an emergency 8.4
- disk 4.3.3
- memory 4.3.2
- real-time 4, 8.4
- transient 8
problems, as a type of incident 6

R

Real-Time ADDM page 8.4
redo logs 10.6.1.4
RMAN 10.6.1.3

S

services
- about 4.1.3, 4.2.4
- monitoring 4.2.4
- monitoring top 4.1.3
sessions
- about 2.1.1, 4.1.2
- active 2.1.1, 2.1.4
- average active 4.1
- top working 4.1.2
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.3
source database, AWR Warehouse 10.2
spikes
- determining cause of 4.4
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, 11.2.2.1, 11.2.2.2
- 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.6.1.5
storage requirements, AWR Warehouse 10.6.1.2
SYSAUX tablespace 10.5, 10.6.1.2

T

throughput, monitoring 4.2.1
top actions, monitoring 4.1.5
top activity
- top SQL 11.2.2
Top Activity page
- about 11.2
top clients, monitoring 4.1.6
top files, monitoring 4.1.8
top modules, monitoring 4.1.4
top objects, monitoring 4.1.9
top PL/SQL, monitoring 4.1.7
top services, monitoring 4.1.3
top SQL
- by wait class 11.2.1
- identifying high-load SQL 11.2
- in Active Session History report 8.3.3
- monitoring 4.1.1
top working sessions, monitoring 4.1.2
transfer errors, AWR Warehouse 10.5
troubleshooting, AWR Warehouse 10.5

U

user activity, monitoring
- about 4.1
- top actions 4.1.5
- top clients 4.1.6
- top files 4.1.8
- top modules 4.1.4
- top objects 4.1.9
- top PL/SQL 4.1.7
- top services 4.1.3
- top SQL 4.1.1
- top working sessions 4.1.2

W

wait classes
- grouped wait events 2.1.2
- viewing high-load SQL by 11.2.1
wait events
- statistics 2.1.2
wait time 2.1.1