Skip Headers
Oracle® Database 2 Day + Performance Tuning Guide
10g Release 2 (10.2)

Part Number B28051-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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