Database 2 Day + Performance Tuning Guide
ContentsOpens a new window
Opens a new window
Page 22 of 22

Index

AOpens a new window  BOpens a new window  COpens a new window  DOpens a new window  EOpens a new window  HOpens a new window  IOpens a new window  JOpens a new window  LOpens a new window  MOpens a new window  NOpens a new window  OOpens a new window  POpens a new window  ROpens a new window  SOpens a new window  TOpens a new window  UOpens a new window  WOpens a new window 

A

ACOpens a new window  ADOpens a new window  AGOpens a new window  ALOpens a new window  ASOpens a new window  AUOpens a new window  AVOpens a new window  AWOpens a new window 
actions
about, 4.1.5Opens a new window
Active Session History
about, 8.1Opens a new window
ASH Analytics page, 4.4Opens a new window
report
about, 8.1Opens a new window
activity over time, 8.3.6Opens a new window
load profile, 8.3.2Opens a new window
running, 8.2Opens a new window
top events, 8.3.1Opens a new window
top SQL, 8.3.3Opens a new window
using, 8.3Opens a new window
sampled data, 8.1Opens a new window
statistics, 2.1.4Opens a new window
active sessions, 2.1.1Opens a new window
captured in Active Session History, 2.1.4Opens a new window
See Automatic Database Diagnostic Monitor
Agent-to-Agent file transfer, 10.6.2.4Opens a new window
alerts
clearing, 6.3Opens a new window
default, 6Opens a new window
performance, 6.1Opens a new window
responding to, 6.2Opens a new window
ASH
See Active Session History
ASH Analytics, 4.4Opens a new window
Automatic Database Diagnostic Monitor
about, 3.1Opens a new window
accessing results, 7.3Opens a new window
analysis, 3.1.1Opens a new window
configuring, 3.2Opens a new window
enabling, 2.2.1Opens a new window
findings
about, 3.4Opens a new window
viewing, 3.3Opens a new window
for Oracle RAC, 3.1.3Opens a new window
identifying high-load SQL, 11.1Opens a new window
Real-Time, 8.4Opens a new window
recommendations
actions, 3.4Opens a new window
implementing, 3.5Opens a new window
interpreting, 3.4Opens a new window
rationales, 3.4Opens a new window
types, 3.1.2Opens a new window
report, 3.3Opens a new window
reviewing results, 3.3Opens a new window
running manually
analyzing current database performance, 7.1Opens a new window
analyzing historical database performance, 7.2Opens a new window
Automatic Memory Management, 10.6.1.1Opens a new window
Automatic SQL Tuning
modifying task attributes, 12.1.2Opens a new window
viewing recommendations, 12.1.2Opens a new window
viewing results, 12.1.2Opens a new window
Automatic Storage Management, 10.6.1.2Opens a new window
Automatic Workload Repository
about, 2.1Opens a new window
baselines, 9.1Opens a new window
compare periods report
about, 9Opens a new window
details, 9.3.2Opens a new window
saving, 9.2.1Opens a new window, 9.2.3Opens a new window
summary, 9.3.1Opens a new window
supplemental information, 9.3.3Opens a new window
using, 9.3Opens a new window
using another baseline, 9.2.1Opens a new window
enabling, 2.2.1Opens a new window
snapshots, 2.1Opens a new window
statistics collected by, 2.1Opens a new window
using, 3.2.3Opens a new window
average active sessions
about, 4.1Opens a new window
AWR
See Automatic Workload Repository
AWR Warehouse
about, 10Opens a new window
ASH Analytics page, 10.4Opens a new window
AWR Report page, 10.4Opens a new window
Compare Period ADDM page, 10.4Opens a new window
Compare Periods Report page, 10.4Opens a new window
credentials, 10.6.2.1Opens a new window
ETL, 10.3Opens a new window
extract errors, 10.5Opens a new window
load errors, 10.5Opens a new window
memory management, 10.6.1.1Opens a new window
Performance Home page, 10.4Opens a new window
set up, 10.1Opens a new window
snapshot view access, 10.2Opens a new window
source database, 10.2Opens a new window
staging location, 10.6.2.3Opens a new window
storage requirements, 10.6.1.2Opens a new window
SYSAUX tablespace, 10.5Opens a new window, 10.6.1.2Opens a new window
transfer errors, 10.5Opens a new window
troubleshooting, 10.5Opens a new window
awrinfo.sql script, 10.6.1.2Opens a new window

B

BAOpens a new window 
baselines
about, 9.1Opens a new window
baseline template
about, 9.1.1.1Opens a new window, 9.1.1.2Opens a new window
comparing, 9.2.1Opens a new window, 9.2.2Opens a new window
computing threshold statistics for, 9.1.3Opens a new window
creating, 9.1.1Opens a new window
deleting, 9.1.2Opens a new window
SQL plan, 12.4Opens a new window

C

CLOpens a new window  COOpens a new window  CPOpens a new window  CUOpens a new window 
clients
about, 4.1.6Opens a new window
CONTROL_MANAGEMENT_PACK_ASSESS parameter, 2.2.1Opens a new window
and ADDM, 3.2.1Opens a new window
and database operations, 5.1.3Opens a new window
CPU
I/O wait, 4.3.1Opens a new window
load, 4.3.1Opens a new window
performance problems, 4.3.1Opens a new window
time, 2.1.1Opens a new window
utilization, monitoring, 4.3.1Opens a new window
customizing the Performance page, 4.5Opens a new window

D

DAOpens a new window  DBOpens a new window  DIOpens a new window 
data access paths, optimizing, 13Opens a new window
Data Guard, 10.6.1.3Opens a new window
Database Home page
accessing, 1.4Opens a new window
database operations
composite operations, defined, 5.1.1Opens a new window
creating, 5.2Opens a new window
enabling monitoring with initialization parameters, 5.1.3Opens a new window
identifying an operation, 5.1.4Opens a new window
monitoring, 5.1Opens a new window
simple operations, defined, 5.1.1Opens a new window
viewing on Monitored SQL Executions page, 5.3Opens a new window
database operations, monitoring
purpose, 5.1.2Opens a new window
database performance
alerts, 6.1Opens a new window
automatic monitoring, 3Opens a new window
comparing, 9Opens a new window
current analysis, 7.1Opens a new window
degradation over time, 9Opens a new window
historical analysis, 7.2Opens a new window
manual monitoring, 7Opens a new window
overview, 2Opens a new window
Database Resource Manager
using, 4.3.1Opens a new window
database statistics
about, 2.1Opens a new window
database time
about, 2.1.1Opens a new window
and ADDM findings, 3.4Opens a new window
in calculating average active sessions, 4.1Opens a new window
database tuning
performance degradation over time, 9Opens a new window
preparing the database, 2.2.1Opens a new window
proactive tuning, 2.2.2Opens a new window
reactive tuning, 2.2.3Opens a new window
real-time performance problems, 4Opens a new window
SQL tuning, 2.2.4Opens a new window
tools, 1.3Opens a new window
transient performance problems, 8Opens a new window
using the Performance page, 4Opens a new window
DB time
See database time
DBIO_EXPECTED parameter
about, 3.2.2Opens a new window
setting, 3.2.1Opens a new window, 3.2.2Opens a new window
DBMS_ADVISOR package
configuring ADDM, 3.2.2Opens a new window
setting DBIO_EXPECTED, 3.2.2Opens a new window
DBMS_SQL_MONITOR package, 5.2Opens a new window
disk
performance problems, 4.3.3Opens a new window
utilization, monitoring, 4.3.3Opens a new window

E

EMOpens a new window  ETOpens a new window  EVOpens a new window  EXOpens a new window 
Emergency Performance page, 8.4Opens a new window
ETL, 10.3Opens a new window
events, 6Opens a new window
execution plans
about, 12Opens a new window
evolving, 12.4.3Opens a new window
viewing for a SQL statement, 11.2.2.3Opens a new window
extract errors, AWR Warehouse, 10.5Opens a new window

H

HIOpens a new window  HOOpens a new window 
high-load SQL
about, 11Opens a new window
identifying using ADDM, 11.1Opens a new window
identifying using top SQL, 11.2Opens a new window
identifying using top SQL by wait class, 11.2.1Opens a new window
statistics, 2.1.5Opens a new window
tuning, 12.1.1Opens a new window, 12.1.2Opens a new window
viewing details, 11.2.2Opens a new window
viewing execution plans, 11.2.2.3Opens a new window
viewing session activity, 11.2.2.2Opens a new window
viewing SQL text, 11.2.2Opens a new window
viewing statistics, 11.2.2.1Opens a new window
viewing tuning information, 11.2.2.4Opens a new window
host activity, monitoring, 4.3Opens a new window
CPU, 4.3.2Opens a new window
CPU utilization, 4.3.1Opens a new window
disk utilization, 4.3.3Opens a new window

I

INOpens a new window 
incidents, 6Opens a new window
index
about, 13Opens a new window
bitmap, 13Opens a new window
B-tree, 13Opens a new window
creating, 13.1Opens a new window
functional, 13Opens a new window
indexes
creating, 2.2.4Opens a new window
initialization parameter, 10.6.1.1Opens a new window
In-Memory Column Store (IM column store), PrefaceOpens a new window
instance activity, monitoring, 4.2Opens a new window
I/O wait times, 4.2.2Opens a new window
parallel execution, 4.2.3Opens a new window
services, 4.2.4Opens a new window
throughput, 4.2.1Opens a new window
I/O wait times, monitoring, 4.2.2Opens a new window

J

JOOpens a new window 
job_queue_processes parameter, 10.6.1.6Opens a new window

L

LOOpens a new window 
load errors, AWR Warehouse, 10.5Opens a new window

M

MAOpens a new window  MEOpens a new window  MOOpens a new window 
materialized view logs
about, 13Opens a new window
creating, 2.2.4Opens a new window, 13.1Opens a new window
materialized views
creating, 2.2.4Opens a new window, 13.1Opens a new window
memory
performance problems, 4.3.2Opens a new window
swap utilization, 4.3.2Opens a new window
utilization, monitoring, 4.3.2Opens a new window
memory management, AWR Warehouse, 10.6.1.1Opens a new window
metrics, 6.1Opens a new window, 9.1.4Opens a new window
modules
about, 4.1.4Opens a new window
Monitored SQL Executions page, 5.3Opens a new window

N

NEOpens a new window 
Network Latency, 10.6.2.4Opens a new window

O

OROpens a new window 
Oracle performance method
about, 2Opens a new window
pretuning tasks, 2.2.1Opens a new window
proactive database tuning tasks, 2.2.2Opens a new window
reactive database tuning tasks, 2.2.3Opens a new window
SQL tuning tasks, 2.2.4Opens a new window
using, 2.2Opens a new window

P

PAOpens a new window  PEOpens a new window  PROpens a new window 
parallel execution, monitoring, 4.2.3Opens a new window
parameters
CONTROL_MANAGEMENT_PACK_ASSESS, 2.2.1Opens a new window, 3.2.1Opens a new window, 5.1.3Opens a new window
DBIO_EXPECTED, 3.2.2Opens a new window
initialization, 9.3.3Opens a new window
STATISTICS_LEVEL, 2.2.1Opens a new window, 2.2.1Opens a new window, 3.2.1Opens a new window, 5.1.3Opens a new window
Performance page
about, 4Opens a new window
customization, 4.5Opens a new window
performance problems
common, 2.3Opens a new window
CPU, 4.3.1Opens a new window
diagnosing, 3.1Opens a new window
diagnosing in an emergency, 8.4Opens a new window
disk, 4.3.3Opens a new window
memory, 4.3.2Opens a new window
real-time, 4Opens a new window, 8.4Opens a new window
transient, 8Opens a new window
problems, as a type of incident, 6Opens a new window

R

REOpens a new window  RMOpens a new window 
Real-Time ADDM page, 8.4Opens a new window
redo logs, 10.6.1.4Opens a new window
RMAN, 10.6.1.3Opens a new window

S

SEOpens a new window  SNOpens a new window  SOOpens a new window  SPOpens a new window  SQOpens a new window  STOpens a new window  SYOpens a new window 
services
about, 4.1.3Opens a new window, 4.2.4Opens a new window
monitoring, 4.2.4Opens a new window
monitoring top, 4.1.3Opens a new window
sessions
about, 2.1.1Opens a new window, 4.1.2Opens a new window
active, 2.1.1Opens a new window, 2.1.4Opens a new window
average active, 4.1Opens a new window
top working, 4.1.2Opens a new window
snapshot upload, AWR Warehouse, 10.3Opens a new window
snapshots
about, 2.1Opens a new window
creating, 3.2.3.1Opens a new window
default interval, 3.2.3Opens a new window
modifying settings, 3.2.3.2Opens a new window
viewing statistics, 3.6Opens a new window
source database, AWR Warehouse, 10.2Opens a new window
spikes
determining cause of, 4.4Opens a new window
SQL Access Advisor
about, 12Opens a new window, 13Opens a new window
filters, 13.1.3Opens a new window
initial options, 13.1.1Opens a new window, 13.2Opens a new window
recommendations
about, 13Opens a new window
details, 13.2.2Opens a new window
implementing, 13.3Opens a new window
options, 13.1.4Opens a new window
reviewing, 13.2Opens a new window
SQL, 13.2.3Opens a new window
summary, 13.2.1Opens a new window
running, 13.1Opens a new window
scheduling, 13.1.5Opens a new window
task options, 13.2.4Opens a new window
workload options, 13.2.4Opens a new window
workload source, 13.1.2Opens a new window
SQL Performance Analyzer
about, 2.3Opens a new window
SQL plan baselines
about, 12.4Opens a new window
capturing automatically, 12.4.1Opens a new window
evolving, 12.4.3Opens a new window
loading manually, 12.4.2Opens a new window
SQL plan management, 12.4Opens a new window
SQL Plan Management Evolve Advisor, 12.4.3Opens a new window
SQL profiles
deleting, 12.3Opens a new window
disabling, 12.3Opens a new window
enabling, 12.3Opens a new window
SQL Tuning Advisor
about, 12Opens a new window
automated maintenance tasks, 12.1.2Opens a new window
implementing recommendations, 12.1.1Opens a new window, 12.1.1Opens a new window
limited scope, 12.1.1Opens a new window
using, 12.1.1Opens a new window, 12.1.2Opens a new window
SQL tuning sets
about, 12.2Opens a new window
creating, 12.2.1Opens a new window
load method, 12.2.1.2Opens a new window
stacked area charts
described, 4.1Opens a new window
statistics
Active Session History, 2.1.4Opens a new window
baselines, 9.1Opens a new window
database, 2.1Opens a new window
database time, 2.1.1Opens a new window, 3.4Opens a new window
default retention, 3.2.3Opens a new window
gathering, 2.1Opens a new window
high-load SQL, 2.1.5Opens a new window, 11.2.2.1Opens a new window, 11.2.2.2Opens a new window
sampled data, 8.1Opens a new window
session, 2.1.3Opens a new window
system, 2.1.3Opens a new window
wait events, 2.1.2Opens a new window
STATISTICS_LEVEL parameter
and ADDM, 3.2.1Opens a new window
and database operations, 5.1.3Opens a new window
setting, 2.2.1Opens a new window
stats collection, 10.6.1.5Opens a new window
storage requirements, AWR Warehouse, 10.6.1.2Opens a new window
SYSAUX tablespace, 10.5Opens a new window, 10.6.1.2Opens a new window

T

THOpens a new window  TOOpens a new window  TROpens a new window 
throughput, monitoring, 4.2.1Opens a new window
top actions, monitoring, 4.1.5Opens a new window
top activity
top SQL, 11.2.2Opens a new window
Top Activity page
about, 11.2Opens a new window
top clients, monitoring, 4.1.6Opens a new window
top files, monitoring, 4.1.8Opens a new window
top modules, monitoring, 4.1.4Opens a new window
top objects, monitoring, 4.1.9Opens a new window
top PL/SQL, monitoring, 4.1.7Opens a new window
top services, monitoring, 4.1.3Opens a new window
top SQL
by wait class, 11.2.1Opens a new window
identifying high-load SQL, 11.2Opens a new window
in Active Session History report, 8.3.3Opens a new window
monitoring, 4.1.1Opens a new window
top working sessions, monitoring, 4.1.2Opens a new window
transfer errors, AWR Warehouse, 10.5Opens a new window
troubleshooting, AWR Warehouse, 10.5Opens a new window

U

USOpens a new window 
user activity, monitoring
about, 4.1Opens a new window
top actions, 4.1.5Opens a new window
top clients, 4.1.6Opens a new window
top files, 4.1.8Opens a new window
top modules, 4.1.4Opens a new window
top objects, 4.1.9Opens a new window
top PL/SQL, 4.1.7Opens a new window
top services, 4.1.3Opens a new window
top SQL, 4.1.1Opens a new window
top working sessions, 4.1.2Opens a new window

W

WAOpens a new window 
wait classes
grouped wait events, 2.1.2Opens a new window
viewing high-load SQL by, 11.2.1Opens a new window
wait events
statistics, 2.1.2Opens a new window
wait time, 2.1.1Opens a new window
Previous PageOpens a new window
Page 22 of 22
Next Page