Index

A  B  C  D  E  H  I  M  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
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.1, 8.2.3
summary, 8.3.1
supplemental information, 8.3.3
using, 8.3
using another baseline, 8.2.1
using snapshot pairs, 8.2.3
enabling, 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, 8.2.2
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.5

D

data access paths, optimizing, 11
database
statistics, 2.1
time, 2.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
determining causes of spikes in activity, 4.4
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
DB time
about, 2.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 text, 9.2.2
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

O

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.2.1
Performance page customization, 4.5
performance problems
common, 2.3
CPU, 4.3.1
diagnosing, 3.1
diagnosing in an emergency, 7.4
disk, 4.3.3
memory, 4.3.2
real time, 7.4
real-time, 4
transient, 7

S

services
about, 4.2.4
monitoring, 4.1.3, 4.2.4
snapshots
about, 2.1
comparing, 8.2.3
creating, 3.2.3.1
default interval, 3.2.3
filtering, 8.2.3
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, 2.3
SQL profiles
deleting, 10.3
disabling, 10.3
enabling, 10.3
SQL Tuning Advisor
about, 10
automated maintenance tasks, 10.1.2
implementing recommendations, 10.1.1, 10.1.1
limited scope, 10.1.1
using, 10.1.1, 10.1.2
SQL tuning sets
about, 10.2
creating, 10.2.1
load method, 10.2.1.2
statistics
Active Session History, 2.1.4
baselines, 8.1
databases, 2.1
DB time, 2.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
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
viewing high-load SQL by, 9.2.1
wait events
statistics, 2.1.2