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