Index

A  B  C  D  E  H  I  J  L  M  N  O  P  R  S  T  U  W 

A

actions
about, 4.1.5
Active Session History
about, 8.1
ASH Analytics page, 4.4
report
about, 8.1
activity over time, 8.3.6
load profile, 8.3.2
running, 8.2
top events, 8.3.1
top SQL, 8.3.3
using, 8.3
sampled data, 8.1
statistics, 2.1.4
active sessions, 2.1.1
captured in Active Session History, 2.1.4
ADDM
See Automatic Database Diagnostic Monitor
Agent-to-Agent file transfer, 10.6.2.4
alerts
clearing, 6.3
default, 6
performance, 6.1
responding to, 6.2
ASH
See Active Session History
ASH Analytics, 4.4
Automatic Database Diagnostic Monitor
about, 3.1
accessing results, 7.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, 11.1
Real-Time, 8.4
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, 7.1
analyzing historical database performance, 7.2
Automatic Memory Management, 10.6.1.1
Automatic SQL Tuning
modifying task attributes, 12.1.2
viewing recommendations, 12.1.2
viewing results, 12.1.2
Automatic Storage Management, 10.6.1.2
Automatic Workload Repository
about, 2.1
baselines, 9.1
compare periods report
about, 9
details, 9.3.2
saving, 9.2.1, 9.2.3
summary, 9.3.1
supplemental information, 9.3.3
using, 9.3
using another baseline, 9.2.1
enabling, 2.2.1
snapshots, 2.1
statistics collected by, 2.1
using, 3.2.3
average active sessions
about, 4.1
AWR
See Automatic Workload Repository
AWR Warehouse
about, 10
ASH Analytics page, 10.4
AWR Report page, 10.4
Compare Period ADDM page, 10.4
Compare Periods Report page, 10.4
credentials, 10.6.2.1
ETL, 10.3
extract errors, 10.5
load errors, 10.5
memory management, 10.6.1.1
Performance Home page, 10.4
set up, 10.1
snapshot view access, 10.2
source database, 10.2
staging location, 10.6.2.3
storage requirements, 10.6.1.2
SYSAUX tablespace, 10.5, 10.6.1.2
transfer errors, 10.5
troubleshooting, 10.5
awrinfo.sql script, 10.6.1.2

B

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

C

clients
about, 4.1.6
CONTROL_MANAGEMENT_PACK_ASSESS parameter, 2.2.1
and ADDM, 3.2.1
and database operations, 5.1.3
CPU
I/O wait, 4.3.1
load, 4.3.1
performance problems, 4.3.1
time, 2.1.1
utilization, monitoring, 4.3.1
customizing the Performance page, 4.5

D

data access paths, optimizing, 13
Data Guard, 10.6.1.3
Database Home page
accessing, 1.4
database operations
composite operations, defined, 5.1.1
creating, 5.2
enabling monitoring with initialization parameters, 5.1.3
identifying an operation, 5.1.4
monitoring, 5.1
simple operations, defined, 5.1.1
viewing on Monitored SQL Executions page, 5.3
database operations, monitoring
purpose, 5.1.2
database performance
alerts, 6.1
automatic monitoring, 3
comparing, 9
current analysis, 7.1
degradation over time, 9
historical analysis, 7.2
manual monitoring, 7
overview, 2
Database Resource Manager
using, 4.3.1
database statistics
about, 2.1
database time
about, 2.1.1
and ADDM findings, 3.4
in calculating average active sessions, 4.1
database tuning
performance degradation over time, 9
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, 8
using the Performance page, 4
DB time
See database time
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
DBMS_SQL_MONITOR package, 5.2
disk
performance problems, 4.3.3
utilization, monitoring, 4.3.3

E

Emergency Performance page, 8.4
ETL, 10.3
events, 6
execution plans
about, 12
evolving, 12.4.3
viewing for a SQL statement, 11.2.2.3
extract errors, AWR Warehouse, 10.5

H

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

I

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

J

job_queue_processes parameter, 10.6.1.6

L

load errors, AWR Warehouse, 10.5

M

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

N

Network Latency, 10.6.2.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
CONTROL_MANAGEMENT_PACK_ASSESS, 2.2.1, 3.2.1, 5.1.3
DBIO_EXPECTED, 3.2.2
initialization, 9.3.3
STATISTICS_LEVEL, 2.2.1, 2.2.1, 3.2.1, 5.1.3
Performance page
about, 4
customization, 4.5
performance problems
common, 2.3
CPU, 4.3.1
diagnosing, 3.1
diagnosing in an emergency, 8.4
disk, 4.3.3
memory, 4.3.2
real-time, 4, 8.4
transient, 8
problems, as a type of incident, 6

R

Real-Time ADDM page, 8.4
redo logs, 10.6.1.4
RMAN, 10.6.1.3

S

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

T

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

U

user activity, monitoring
about, 4.1
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 SQL, 4.1.1
top working sessions, 4.1.2

W

wait classes
grouped wait events, 2.1.2
viewing high-load SQL by, 11.2.1
wait events
statistics, 2.1.2
wait time, 2.1.1