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

function-based, 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

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, 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