Skip Headers
Oracle® Database 2 Day + Performance Tuning Guide
12c Release 1 (12.1)

E17635-10
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

Index

A  B  C  D  E  H  I  M  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
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, 10.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 SQL Tuning
modifying task attributes, 11.1.2
viewing recommendations, 11.1.2
viewing results, 11.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

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, 11.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, 12
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
events, 6
execution plans
about, 11
evolving, 11.4.3
viewing for a SQL statement, 10.2.2.3

H

high-load SQL
about, 10
identifying using ADDM, 10.1
identifying using top SQL, 10.2
identifying using top SQL by wait class, 10.2.1
statistics, 2.1.5
tuning, 11.1.1, 11.1.2
viewing details, 10.2.2
viewing execution plans, 10.2.2.3
viewing session activity, 10.2.2.2
viewing SQL text, 10.2.2
viewing statistics, 10.2.2.1
viewing tuning information, 10.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, 12
bitmap, 12
B-tree, 12
creating, 12.1
functional, 12
indexes
creating, 2.2.4
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

M

materialized view logs
about, 12
creating, 2.2.4, 12.1
materialized views
creating, 2.2.4, 12.1
memory
performance problems, 4.3.2
swap utilization, 4.3.2
utilization, monitoring, 4.3.2
metrics, 6.1, 9.1.4
modules
about, 4.1.4
Monitored SQL Executions page, 5.3

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

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
snapshots
about, 2.1
creating, 3.2.3.1
default interval, 3.2.3
modifying settings, 3.2.3.2
viewing statistics, 3.6
spikes
determining cause of, 4.4
SQL Access Advisor
about, 11, 12
filters, 12.1.3
initial options, 12.1.1, 12.2
recommendations
about, 12
details, 12.2.2
implementing, 12.3
options, 12.1.4
reviewing, 12.2
SQL, 12.2.3
summary, 12.2.1
running, 12.1
scheduling, 12.1.5
task options, 12.2.4
workload options, 12.2.4
workload source, 12.1.2
SQL Performance Analyzer
about, 2.3
SQL plan baselines
about, 11.4
capturing automatically, 11.4.1
evolving, 11.4.3
loading manually, 11.4.2
SQL plan management, 11.4
SQL Plan Management Evolve Advisor, 11.4.3
SQL profiles
deleting, 11.3
disabling, 11.3
enabling, 11.3
SQL Tuning Advisor
about, 11
automated maintenance tasks, 11.1.2
implementing recommendations, 11.1.1, 11.1.1
limited scope, 11.1.1
using, 11.1.1, 11.1.2
SQL tuning sets
about, 11.2
creating, 11.2.1
load method, 11.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, 10.2.2.1, 10.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

T

throughput, monitoring, 4.2.1
top actions, monitoring, 4.1.5
top activity
top SQL, 10.2.2
Top Activity page
about, 10.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, 10.2.1
identifying high-load SQL, 10.2
in Active Session History report, 8.3.3
monitoring, 4.1.1
top working sessions, monitoring, 4.1.2

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, 10.2.1
wait events
statistics, 2.1.2
wait time, 2.1.1