Skip Headers
Oracle® Database 2 Day + Performance Tuning Guide
11g Release 1 (11.1)

B28275-02
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
PDF · Mobi · ePub

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
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.2
initial environment
establishing, 12.3.2.2
methodology, 12.2
performance data
collecting post-change version, 12.3.2.5
collecting pre-change version, 12.3.2.3
comparing, 12.3.2.6
running, 12.3
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.2.1
SQL workload
capturing, 12.2.1
executing, 12.2.3
transporting, 12.2.1
system change
making, 12.3.2.4
testing parameter change, 12.3.1
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