Index

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

A

actions
- about 1
Active Session History
- about 1
- ASH Analytics page 1
- report
  - about 1
  - activity over time 1
  - load profile 1
  - running 1
  - top events 1
  - top SQL 1
  - using 1
- sampled data 1
- statistics 1
active sessions
- captured in Active Session History 1
ADDM
- See: Automatic Database Diagnostic Monitor
Agent-to-Agent file transfer 1
alerts
- clearing 1
- default 1
- performance 1
- responding to 1
ASH
- See: Active Session History
ASH Analytics 1
Automatic Database Diagnostic Monitor
- about 1
- accessing results 1
- analysis 1
- configuring 1
- findings
  - about 1
  - viewing 1
- for Oracle RAC 1
- identifying high-load SQL 1
- Real-Time 1
- recommendations
  - actions 1
  - implementing 1
  - interpreting 1
  - rationales 1
  - types 1
- report 1
- reviewing results 1
- running manually
  - analyzing current database performance 1
  - analyzing historical database performance 1
Automatic Memory Management 1
Automatic SQL Tuning
- modifying task attributes 1
- viewing recommendations 1
- viewing results 1
Automatic Storage Management 1
Automatic Workload Repository
- about 1
- baselines 1
- compare periods report
  - about 1
  - details 1
  - saving 1 , 2
  - summary 1
  - supplemental information 1
  - using 1
  - using another baseline 1
- snapshots 1
- statistics collected by 1
- using 1
average active sessions
- about 1
AWR
- See: Automatic Workload Repository
awrinfo.sql script 1
AWR Warehouse
- about 1
- ASH Analytics page 1
- AWR Report page 1
- Compare Period ADDM page 1
- Compare Periods Report page 1
- credentials 1
- ETL 1
- extract errors 1
- load errors 1
- memory management 1
- Performance Home page 1
- set up 1
- snapshot view access 1
- source database 1
- staging location 1
- storage requirements 1
- SYSAUX tablespace 1 , 2
- transfer errors 1
- troubleshooting 1

B

baselines
- about 1
- baseline template
  - about 1 , 2
- comparing 1 , 2
- computing threshold statistics for 1
- creating 1
- deleting 1
- SQL plan 1

C

clients
- about 1
CONTROL_MANAGEMENT_PACK_ASSESS parameter
- and ADDM 1
- and database operations 1
CPU
- I/O wait 1
- load 1
- performance problems 1
- time 1
- utilization, monitoring 1
customizing the Performance page 1

D

data access paths, optimizing 1
Database Home page
- accessing 1
database operations
- composite operations, defined 1
- creating 1
- enabling monitoring with initialization parameters 1
- identifying an operation 1
- monitoring 1
- simple operations, defined 1
- viewing on Monitored SQL Executions page 1
database operations, monitoring
- purpose 1
database performance
- alerts 1
- automatic monitoring 1
- comparing 1
- current analysis 1
- degradation over time 1
- historical analysis 1
- manual monitoring 1
- overview 1
Database Resource Manager
- using 1
database statistics
- about 1
database time
- about 1
- and ADDM findings 1
- in calculating average active sessions 1
database tuning
- performance degradation over time 1
- preparing the database 1
- proactive tuning 1
- reactive tuning 1
- real-time performance problems 1
- SQL tuning 1
- tools 1
- transient performance problems 1
- using the Performance page 1
Data Guard 1
DBIO_EXPECTED parameter
- setting 1 , 2
DBMS_ADVISOR package
- configuring ADDM 1
- setting DBIO_EXPECTED 1
DBMS_SQL_MONITOR package 1
DB time
- See: database time
disk
- performance problems 1
- utilization, monitoring 1

E

Emergency Performance page 1
ETL 1
events 1
execution plans
- about 1
- evolving 1
- viewing for a SQL statement 1
extract errors, AWR Warehouse 1

H

high-load SQL
- about 1
- identifying using ADDM 1
- identifying using top SQL 1
- identifying using top SQL by wait class 1
- statistics 1
- tuning 1 , 2
- viewing details 1
- viewing execution plans 1
- viewing session activity 1
- viewing SQL text 1
- viewing statistics 1
- viewing tuning information 1
host activity, monitoring
- CPU 1
- CPU utilization 1
- disk utilization 1

I

I/O wait times, monitoring 1
incidents 1
index
- about 1
- bitmap 1
- B-tree 1
- creating 1
- functional 1
indexes
- creating 1
initialization parameter 1
In-Memory Column Store (IM column store) 1
instance activity, monitoring
- I/O wait times 1
- parallel execution 1
- services 1
- throughput 1

J

job_queue_processes parameter 1

L

load errors, AWR Warehouse 1

M

materialized view logs
- about 1
- creating 1 , 2
materialized views
- creating 1 , 2
memory
- performance problems 1
- swap utilization 1
- utilization, monitoring 1
memory management, AWR Warehouse 1
metrics 1 , 2
modules
- about 1
Monitored SQL Executions page 1

N

Network Latency 1

O

Oracle performance method
- about 1
- pretuning tasks 1
- proactive database tuning tasks 1
- reactive database tuning tasks 1
- SQL tuning tasks 1
- using 1

P

parallel execution, monitoring 1
parameters
- CONTROL_MANAGEMENT_PACK_ASSESS 1 , 2 , 3
- initialization 1
- STATISTICS_LEVEL 1 , 2
Performance page
- about 1
- customization 1
performance problems
- common 1
- CPU 1
- diagnosing 1
- diagnosing in an emergency 1
- disk 1
- memory 1
- real-time 1 , 2
- transient 1
problems, as a type of incident 1

R

Real-Time ADDM page 1
redo logs 1
RMAN 1

S

services
- about 1 , 2
- monitoring 1
- monitoring top 1
sessions
- about 1 , 2
- active 1 , 2
- average active 1
- top working 1
snapshots
- about 1
- creating 1
- default interval 1
- modifying settings 1
- viewing statistics 1
snapshot upload, AWR Warehouse 1
source database, AWR Warehouse 1
spikes
- determining cause of 1
SQL Access Advisor
- about 1 , 2
- filters 1
- initial options 1 , 2
- recommendations
  - about 1
  - details 1
  - implementing 1
  - options 1
  - reviewing 1
  - SQL 1
  - summary 1
- running 1
- scheduling 1
- task options 1
- workload options 1
- workload source 1
SQL Performance Analyzer
- about 1
SQL plan baselines
- about 1
- capturing automatically 1
- evolving 1
- loading manually 1
SQL plan management 1
SQL Plan Management Evolve Advisor 1
SQL profiles
- deleting 1
- disabling 1
- enabling 1
SQL Tuning Advisor
- about 1
- automated maintenance tasks 1
- implementing recommendations 1
- limited scope 1
- using 1 , 2
SQL tuning sets
- about 1
- creating 1
- load method 1
stacked area charts
- described 1
statistics
- Active Session History 1
- baselines 1
- database 1
- database time 1 , 2
- default retention 1
- gathering 1
- high-load SQL 1 , 2 , 3
- sampled data 1
- session 1
- system 1
- wait events 1
STATISTICS_LEVEL parameter
- and ADDM 1
- and database operations 1
stats collection 1
storage requirements, AWR Warehouse 1
SYSAUX tablespace 1 , 2

T

throughput, monitoring 1
top actions, monitoring 1
top activity
- top SQL 1
Top Activity page
- about 1
top clients, monitoring 1
top files, monitoring 1
top modules, monitoring 1
top objects, monitoring 1
top PL/SQL, monitoring 1
top services, monitoring 1
top SQL
- by wait class 1
- identifying high-load SQL 1
- in Active Session History report 1
- monitoring 1
top working sessions, monitoring 1
transfer errors, AWR Warehouse 1
troubleshooting, AWR Warehouse 1

U

user activity, monitoring
- about 1
- top actions 1
- top clients 1
- top files 1
- top modules 1
- top objects 1
- top PL/SQL 1
- top services 1
- top SQL 1
- top working sessions 1

W

wait classes
- grouped wait events 1
- viewing high-load SQL by 1
wait events
- statistics 1
wait time 1