Index
A B C D E H I M N O P S T U W
A
- actions
-
- about, 4.1.5
- Active Session History
-
- about, 7.1
- report
-
- about, 7.1
- activity over time, 7.3.7
- load profile, 7.3.2
- running, 7.2
- top events, 7.3.1
- 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.1
- configuring, 3.2
- DB time, 3.1.1
- enabling, 2.2.1
- findings
-
- about, 3.4
- viewing, 3.3
- for Oracle RAC, 3.1.3
- identifying high-load SQL, 9.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, 6.1
- analyzing historical database performance, 6.2
- Automatic SQL Tuning
-
- modifying task attributes, 10.1.2
- viewing recommendations, 10.1.2
- viewing results, 10.1.2
- Automatic Workload Repository
-
- about, 2.1
- baselines, 8.1
- compare periods report
-
- about, 8
- details, 8.3.2
- saving, 8.2.1, 8.2.2
- summary, 8.3.1
- supplemental information, 8.3.3
- using, 8.3
- using another baseline, 8.2.1
- using snapshot pairs, 8.2.2
- 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
- baseline template
-
- about, 8.1.1.1, 8.1.1.2
- comparing, 8.2.1
- computing threshold statistics for, 8.1.3
- creating
-
- single, 8.1.1.1
- deleting, 8.1.2
C
- clients
-
- about, 4.1.6
- CONTROL_MANAGEMENT_PACK_ACCESS parameter and ADDM, 3.2.1
- CPU
-
- I/O wait, 4.3.1
- load, 4.3.1
- performance problems, 4.3.1
- utilization
-
- about, 4.3
- monitoring, 4.3.1
- customizing the Performance page, 4.4
D
- data access paths, optimizing, 11
- database
-
- statistics, 2.1
- time, 2.1.1, 3.1.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 Performance page, 4
- database upgrade
-
- simulating with SQL Performance Analyzer, 12.3.1
- DB time
-
- about, 2.1.1
- and ADDM, 3.1.1
- and ADDM finding, 3.4
- DBIO_EXPECTED parameter
-
- about, 3.2.2
- setting, 3.2.1, 3.2.2
- DBMS_ADVISOR package
-
- configuring ADDM, 3.2.2
- setting DBIO_EXPECTED, 3.2.2
- disk
-
- performance problems, 4.3.3
- utilization
-
- about, 4.3
- monitoring, 4.3.3
E
- 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.1, 10.1.2
- 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
- indexes
-
- creating, 2.2.4
- instance activity
-
- monitoring, 4.2
- monitoring I/O wait times, 4.2.2
- monitoring parallel execution, 4.2.3
- monitoring services, 4.2.4
- monitoring throughput, 4.2.1
- I/O wait times, monitoring, 4.2.2
M
- materialized view logs
-
- about, 11
- creating, 2.2.4, 11.1
- materialized views
-
- creating, 2.2.4, 11.1
- memory
-
- performance problems, 4.3.2
- swap utilization, 4.3.2
- utilization
-
- about, 4.3
- monitoring, 4.3.2
- metrics, 5.1, 8.1.4
- modules, 4.1.4
N
- new features, list of, Preface
O
- optimizer, use of SQL profiles in, 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
- parallel execution, monitoring, 4.2.3
- parameters
-
- DBIO_EXPECTED, 3.2.2
- initialization, 8.3.3
- STATISTICS_LEVEL, 2.1, 2.2.1
- Performance page customization, 4.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, 7
S
- services
-
- about, 4.1.3, 4.2.4
- monitoring, 4.1.3, 4.2.4
- sessions, monitoring, 4.1.2
- snapshots
-
- about, 2.1
- comparing, 8.2.2
- creating, 3.2.3.1
- default interval, 3.2.3
- 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
- options, 11.1.4
- reviewing, 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 Performance Analyzer
-
- about, 12
- database environment
-
- setting up, 12.2.2
- following guided workflow, 12.3.3
- initial environment
-
- establishing, 12.3.3.2
- methodology, 12.2
- performance data
-
- collecting post-change version, 12.3.3.5
- collecting pre-change version, 12.3.3.3
- comparing, 12.3.3.6
- running, 12.3
- simulating database upgrade, 12.3.1
- SQL Performance Analyzer report
-
- general information, 12.4.1
- global statistics, 12.4.2
- global statistics details, 12.4.3
- reviewing, 12.4
- SQL Tuning Set
-
- selecting, 12.3.3.1
- SQL workload
-
- capturing, 12.2.1
- executing, 12.2.3
- transporting, 12.2.1
- system change
-
- making, 12.3.3.4
- testing parameter change, 12.3.2
- usage, 12.1
- 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
- automated maintenance tasks, 10.1.2
- comprehensive scope, 10.1.1
- implementing recommendations, 10.1.1
- limited scope, 10.1.1
- using, 10.1.1, 10.1.2
- viewing information, 9.2.2.4
- viewing results, 10.1.1
- SQL Tuning Sets
-
- about, 10.2, 12.3
- creating, 10.2.1
- load method, 10.2.1.2
- transporting, 10.2
- statistics
-
- Active Session History, 2.1.4
- baselines, 8.1
- databases, 2.1
- DB time, 2.1.1, 3.1.1, 3.4
- default retention, 3.2.3
- 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
- sampled data, 7.1
- session, 2.1.3
- system, 2.1.3
- time model, 2.1.1
- wait events, 2.1.2
- STATISTICS_LEVEL parameter
-
- and ADDM, 3.2.1
- and the Automatic Workload Repository, 2.1
- setting, 2.2.1
T
- throughput, monitoring, 4.2.1
- time model statistics
-
- about, 2.1.1
- Top Actions
-
- user activity, 4.1.5
- top activity
-
- top SQL, 9.2, 9.2.2
- Top Clients
-
- user activity, 4.1.6
- Top Files
-
- user activity, 4.1.8
- Top Modules
-
- user activity, 4.1.4
- Top Objects
-
- user activity, 4.1.9
- Top PL/SQL
-
- user activity, 4.1.7
- Top Services
-
- user activity, 4.1.3
- 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
- Top Working Sessions
-
- user activity, 4.1.2
U
- user activity
-
- 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 services, 4.1.3
- Top SQL, 4.1.1
- Top Working Sessions, 4.1.2
W
- wait class
-
- about, 4.1
- legend, 4.1
- viewing high-load SQL by, 9.2.1
- wait events
-
- statistics, 2.1.2
