Index
A B C D E H I L M O P S T U W
A
- actions
-
- about, 4.1.5
- monitoring, 4.1.5
- Active Session History
-
- about, 7.1
- report
-
- about, 7.1
- activity over time, 7.3.6
- load profiles, 7.3.2
- running, 7.2
- saving, 7.2
- top events, 7.3.1
- top files, 7.3.5
- top latches, 7.3.5
- top objects, 7.3.5
- top sessions, 7.3.4
- Top SQL, 7.3.3
- using, 7.3
- sampled data, 7.1
- statistics, 2.1.4
- alerts
-
- clearing, 5.3
- default, 5
- performance, 5.1
- purging, 5.3
- responding to, 5.2
- Automatic Database Diagnostic Monitor
-
- about, 3.1
- accessing results, 6.3
- analysis, 3.1
- and DB time, 3.1
- configuring, 3.2
- enabling, 2.2.1, 3.2.1
- findings
-
- about, 3.4
- viewing, 3.3
- identifying high-load SQL, 9.1
- recommendations
-
- actions, 3.4
- implementing, 3.5
- interpreting, 3.4
- rationales, 3.4
- types, 3.1
- report, 3.3
- reviewing results, 3.3
- running manually
-
- analyzing current database performance, 6.1
- analyzing historical database performance, 6.2
- Automatic Workload Repository
-
- about, 2.1
- baselines, 8.1
- compare periods report
-
- about, 8
- advisory statistics, 8.3.9, 8.3.15
- dictionary cache statistics, 8.3.13
- instance activity statistics, 8.3.7
- I/O statistics, 8.3.8
- latch statistics, 8.3.11
- library cache statistics, 8.3.14
- operating system statistics, 8.3.4
- saving, 8.2.1, 8.2.2
- segment statistics, 8.3.12
- service statistics, 8.3.5
- SQL statistics, 8.3.6
- summary, 8.3.1
- time model statistics, 8.3.3
- using, 8.3
- using another baseline, 8.2.1
- using snapshot pairs, 8.2.2
- wait events, 8.3.2
- wait statistics, 8.3.10
- configuring, 2.1
- enabling, 2.1, 2.2.1
- snapshots, 2.1
- statistics collected, 2.1
- using, 3.2.3
B
- baselines
-
- about, 8.1
- comparing, 8.2.1
- creating, 8.1
- example, 8.1
- buffer waits
-
- about, 8.3.10.1
C
- CPU
-
- load, 4.3.1
- performance problems, 4.3.1
- utilization
-
- about, 4.3
- monitoring, 4.3.1
D
- data access paths
-
- optimizing, 11
- database
-
- statistics, 2.1
- time, 2.1.1, 3.1, 3.4
- database performance
-
- alerts, 5.1
- automatic monitoring, 3
- comparing, 8
- current analysis, 6.1
- degradation over time, 8
- historical analysis, 6.2
- manual monitoring, 6
- overview, 2
- Database Resource Manager
-
- using, 4.3.1
- database tuning
-
- performance degradation over time, 8
- 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, 7
- using the Database Performance page, 4
- DB time
-
- about, 2.1.1
- and ADDM, 3.1
- and ADDM finding, 3.4
- DBIO_EXPECTED parameter
-
- about, 3.2.2
- setting, 3.2.2
- DBMS_ADVISOR package
-
- configuring ADDM, 3.2.2
- setting DBIO_EXPECTED, 3.2.2
- dictionary cache
-
- about, 8.3.13
- disk
-
- performance problems, 4.3.3
- utilization
-
- about, 4.3
- monitoring, 4.3.3
E
- enqueue
-
- about, 8.3.10.2
- execution plan
-
- about, 10
- viewing for a SQL statement, 9.2.2.3
H
- high-load SQL
-
- about, 9
- identifying using ADDM, 9.1
- identifying using Top SQL, 9.2
- identifying using Top SQL by wait class, 9.2.1
- statistics, 2.1.5
- tuning, 10.1
- viewing details, 9.2.2
- viewing execution plans, 9.2.2.3
- viewing session activity, 9.2.2.2
- viewing SQL profiles, 9.2.2.4
- viewing SQL text, 9.2.2
- viewing SQL Tuning Advisor tasks, 9.2.2.4
- viewing statistics, 9.2.2.1
- viewing tuning information, 9.2.2.4
- host activity
-
- monitoring, 4.3
I
- index
-
- about, 11
- bitmap, 11
- B-tree, 11
- creating, 11.1
- functional, 11
- instance activity
-
- comparing, 8.3.7
- monitoring, 4.2
L
- latches
-
- about, 7.3.5.3
- library cache
-
- about, 8.3.14
M
- materialized view logs
-
- about, 11
- creating, 11.1
- materialized views
-
- about, 11
- creating, 11.1
- memory
-
- performance problems, 4.3.2
- PGA statistics, 8.3.9
- SGA statistics, 8.3.15
- swap utilization, 4.3.2
- utilization
-
- about, 4.3
- monitoring, 4.3.2
- modules
-
- about, 4.1.4
- monitoring, 4.1.4
O
- optimizer
-
- about, 10
- using SQL profiles, 10.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
P
- parameters
-
- DBIO_EXPECTED, 3.2.2
- initialization, 8.3.16
- STATISTICS_LEVEL, 2.1, 2.2.1, 3.2.1
- performance problems
-
- common, 2.3
- CPU, 4.3.1
- diagnosing, 3.1
- disk, 4.3.3
- memory, 4.3.2
- real-time, 4
- transient, 7
- preserved snapshot sets
-
- creating, 8.1
S
- services
-
- about, 4.1.3
- monitoring, 4.1.3
- sessions
-
- about, 4.1.2
- monitoring, 4.1.2
- snapshots
-
- about, 2.1
- comparing, 8.2.2
- creating, 3.2.3.1
- default interval, 3.2.3
- example, 3.2.3.1
- filtering, 8.2.2
- modifying settings, 3.2.3.2
- viewing statistics, 3.6
- SQL Access Advisor
-
- about, 10, 11
- filters, 11.1.3
- initial options, 11.1.1
- recommendations
-
- about, 11
- details, 11.2.2
- implementing, 11.3, 11.3
- options, 11.1.4
- reviewing, 11.2, 11.2
- SQL, 11.2.3
- summary, 11.2.1
- running, 11.1
- scheduling, 11.1.5
- task options, 11.2.4
- workload options, 11.2.4
- workload source, 11.1.2
- SQL profiles
-
- about, 10.3
- deleting, 10.3
- disabling, 10.3
- enabling, 10.3
- viewing information, 9.2.2.4
- SQL Tuning Advisor
-
- about, 10
- comprehensive scope, 10.1
- implementing recommendations, 10.1
- limited scope, 10.1
- using, 10.1
- viewing information, 9.2.2.4
- viewing results, 10.1
- SQL tuning sets
-
- about, 10.2, 10.2
- creating, 10.2
- transporting, 10.2
- statistics
-
- Active Session History, 2.1.4
- baselines, 8.1
- databases, 2.1
- DB time, 2.1.1, 3.1, 3.4
- default retention, 3.2.3
- dictionary cache, 8.3.13
- gathered by the Automatic Workload Repository, 2.1
- gathering, 2.1
- high-load SQL, 2.1.5, 9.2.2.1, 9.2.2.2
- instance activity, 8.3.7
- I/O, 8.3.8
- latch, 8.3.11
- library cache, 8.3.14
- operating system
-
- comparing, 8.3.4
- PGA memory, 8.3.9
- sampled data, 7.1
- segment, 8.3.12
- service, 8.3.5
- session, 2.1.3
- SGA memory, 8.3.15
- SQL, 8.3.6
- system, 2.1.3
- time model, 2.1.1, 8.3.3
- wait events, 2.1.2
- waits, 8.3.10
- STATISTICS_LEVEL parameter
-
- and ADDM, 3.2.1
- and the Automatic Workload Repository, 2.1
- setting, 2.2.1
T
- time model statistics
-
- about, 2.1.1
- comparing, 8.3.3
- top activity
-
- top actions, 4.1.5
- top modules, 4.1.4
- top SQL, 9.2
- top sessions
-
- Active Session History report, 7.3.4
- user activity, 4.1.2
- Top SQL
-
- Active Session History report, 7.3.3
- by wait class, 9.2.1
- identifying high-load SQL, 9.2
- user activity, 4.1.1
U
- user activity
-
- monitoring, 4.1
- top services, 4.1.3
- top sessions, 4.1.2
- Top SQL, 4.1.1
W
- wait class
-
- about, 4.1
- legend, 4.1
- viewing high-load SQL by, 9.2.1
- wait events
-
- comparing, 8.3.2
- statistics, 2.1.2
