Index
A
- about 13
- actions
- about 4.1.5
- Active Session History
- 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
- ASH
- See: Active Session History
- ASH Analytics 4.4
- Automatic Database Diagnostic Monitor
- Automatic Memory Management 10.6.1.1
- Automatic SQL Tuning
- Automatic Storage Management 10.6.1.2
- Automatic Workload Repository
- 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
D
- data access paths, optimizing 13
- Database Home page
- accessing 1.4
- database operations
- database operations, monitoring
- purpose 5.1.2
- database performance
- Database Resource Manager
- using 4.3.1
- database statistics
- about 2.1
- database time
- database tuning
- Data Guard 10.6.1.3
- DBIO_EXPECTED parameter
- DBMS_ADVISOR package
- DBMS_SQL_MONITOR package 5.2
- DB time
- See: database time
- disk
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
I
P
S
- services
- sessions
- snapshots
- snapshot upload, AWR Warehouse 10.3
- source database, AWR Warehouse 10.2
- spikes
- determining cause of 4.4
- SQL Access Advisor
- SQL Performance Analyzer
- about 2.3
- SQL plan baselines
- SQL plan management 12.4
- SQL Plan Management Evolve Advisor 12.4.3
- SQL profiles
- SQL Tuning Advisor
- SQL tuning sets
- stacked area charts
- described 4.1
- statistics
- STATISTICS_LEVEL parameter
- 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
- top working sessions, monitoring 4.1.2
- transfer errors, AWR Warehouse 10.5
- troubleshooting, AWR Warehouse 10.5