Database Performance Tuning Guide
ContentsOpens a new window
Opens a new window

Index

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

A

ACOpens a new window  ALOpens a new window  APOpens a new window  AUOpens a new window  AWOpens a new window 
Active Session History, 5.1.2Opens a new window
report
activity over time, 9.3.8Opens a new window
load profile, 9.3.2Opens a new window
top events, 9.3.1Opens a new window
top files, 9.3.7Opens a new window
top Java, 9.3.5Opens a new window
top latches, 9.3.7Opens a new window
top objects, 9.3.7Opens a new window
top PL/SQL, 9.3.4Opens a new window
top sessions, 9.3.6Opens a new window
Top SQL, 9.3.3Opens a new window
using, 9.3Opens a new window
reports, 9.2Opens a new window
allocation of memory, 11.1Opens a new window
applications
deploying, 2.7Opens a new window
design principles, 2.5Opens a new window
development trends, 2.5.7Opens a new window
implementing, 2.5.6Opens a new window
Automatic Database Diagnostic Monitor
actions and rationales of recommendations, 7.1.4Opens a new window
analysis results example, 7.1.5Opens a new window
and DB time, 7.1.1Opens a new window
CONTROL_MANAGEMENT_PACK_ACCESS parameter, 7.2Opens a new window
DBIO_EXPECTED, 7.2Opens a new window
example report, 7.1.5Opens a new window
findings, 7.1.4Opens a new window
overview, 7.1Opens a new window
results, 7.1.4Opens a new window
setups, 7.2Opens a new window
STATISTICS_LEVEL parameter, 7.2Opens a new window
types of problems considered, 7.1.1Opens a new window
types of recommendations, 7.1.4Opens a new window
automatic database diagnostic monitoring, 1.2.1Opens a new window
automatic segment-space management, 4.1.4.1Opens a new window, 10.3.2.2.1Opens a new window, 17.2.6.2Opens a new window
Automatic shared memory management, 12.1Opens a new window
automatic SQL tuning, 1.2.1Opens a new window
automatic undo management, 4.1.2Opens a new window, 4.1.2Opens a new window
Automatic Workload Repository, 1.2.1Opens a new window
compare periods report
about, 8.1Opens a new window
advisory statistics, 8.3.2.8Opens a new window, 8.3.2.16Opens a new window
details, 8.3.2Opens a new window
dictionary cache statistics, 8.3.2.14Opens a new window
instance activity statistics, 8.3.2.6Opens a new window
I/O statistics, 8.3.2.7Opens a new window
latch statistics, 8.3.2.11Opens a new window
library cache statistics, 8.3.2.15Opens a new window
operating system statistics, 8.3.2.2Opens a new window
segment statistics, 8.3.2.12Opens a new window, 8.3.2.13Opens a new window
service statistics, 8.3.2.4Opens a new window
SQL statistics, 8.3.2.5Opens a new window
summary, 8.3.1Opens a new window
supplemental information, 8.3.3Opens a new window
time model statistics, 8.3.2.1Opens a new window
undo statistics, 8.3.2.10Opens a new window
using, 8.3Opens a new window
wait events, 8.3.2.3Opens a new window
wait statistics, 8.3.2.9Opens a new window
configuring, 6.2.1Opens a new window
DBMS_WORKLOAD_REPOSITORY package, 6.2.2.1Opens a new window, 6.2.3.1Opens a new window, 6.2.4.1Opens a new window
default settings, 6.1.4Opens a new window
factors affecting space usage, 6.1.4Opens a new window
managing with APIs, 6.2.2.1Opens a new window, 6.2.3.1Opens a new window, 6.2.4.1Opens a new window
minimizing space usage, 6.1.4Opens a new window
overview, 6.1.1Opens a new window
recommendations for retention period, 6.1.4Opens a new window
reports, 6.3.2.1Opens a new window
retention period, 6.1.4Opens a new window
settings in DBA_HIST_WR_CONTROL view, 6.2.2.4.1Opens a new window
space usage, 6.1.4Opens a new window
statistics collected, 6.1.1Opens a new window
turning off automatic snapshot collection, 6.1.4Opens a new window
unusual percentages in reports, 6.3Opens a new window
views for accessing data, 6.2.6Opens a new window
awrrpt.sql
Automatic Workload Repository report, 6.3.2.1Opens a new window

B

BAOpens a new window  BEOpens a new window  BIOpens a new window  BLOpens a new window  BOOpens a new window  BUOpens a new window 
baselines, 1.1.2.2Opens a new window, 6.1.3Opens a new window
performance, 6.1Opens a new window
benchmarking workloads, 2.6.2.2Opens a new window
big bang rollout strategy, 2.7.1Opens a new window
bitmap indexes, 2.5.3.2.2Opens a new window
block cleanout, 10.2.4.2Opens a new window
block size
choosing, 17.2.6Opens a new window
optimal, 17.2.6Opens a new window
bottlenecks
elimination, 1.1.2.4.2Opens a new window
fixing, 3.1Opens a new window
identifying, 3.1Opens a new window
memory, 11.1Opens a new window
resource, 10.3.19.1.2Opens a new window
B-tree indexes, 2.5.3.2.1Opens a new window
buffer busy wait events, 10.2.3Opens a new window, 10.3.2Opens a new window
actions, 10.3.2.2Opens a new window
buffer cache
contention, 10.3.3Opens a new window, 10.3.4Opens a new window, 10.3.11.2Opens a new window
hit ratio, 13.2.2Opens a new window
buffer pools
default cache, 13.3.1.1Opens a new window
KEEP, 13.3.6Opens a new window
KEEP cache, 13.3.1.1Opens a new window
multiple, 13.3Opens a new window
RECYCLE cache, 13.3.1.1Opens a new window
buffer waits
about, 8.3.2.9.1Opens a new window
business logic, 2.4.1.2.2Opens a new window, 2.5.6Opens a new window

C

CHOpens a new window  CLOpens a new window  COOpens a new window  CPOpens a new window  CROpens a new window  CUOpens a new window 
chained rows, 10.2.4.3Opens a new window
classes
wait events, 5.1.3Opens a new window, 10.1.3.2Opens a new window
client/server applications, 18.4.1.2Opens a new window
column order
indexes, 2.5.3.5Opens a new window
COMPATIBLE initialization parameter, 4.1.1Opens a new window
components
hardware, 2.4.1.1Opens a new window
software, 2.4.1.2Opens a new window
conceptual modeling, 3.1.2Opens a new window
consistency
read, 10.2.4.2Opens a new window
consistent gets from cache statistic, 13.2.2Opens a new window
contention
library cache latch, 10.3.11.3Opens a new window
memory, 10Opens a new window, 11.1Opens a new window
shared pool, 10.3.11.3Opens a new window
tuning, 10Opens a new window
wait events, 10.3.11Opens a new window
context switches, 18.4.1.4.2Opens a new window
CONTROL_FILES initialization parameter, 4.1.1Opens a new window
CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter
enabling automatic database diagnostic monitoring, 7.2Opens a new window
CPUs, 2.4.1.1.1Opens a new window
statistics, 10.1.2.1.3Opens a new window
utilization, 18.4.1Opens a new window
CREATE INDEX statement
PARALLEL clause, 4.2.3Opens a new window
CURSOR_SHARING initialization parameter, 14.2.1Opens a new window
CURSOR_SPACE_FOR_TIME initialization parameter, 14.3.2Opens a new window
cursors
accessing, 14.2.6Opens a new window
sharing, 14.2.6Opens a new window

D

DAOpens a new window  DBOpens a new window  DEOpens a new window  DIOpens a new window 
data
and transactions, 2.4.1.2.4Opens a new window
cache, 18.1.1Opens a new window
gathering, 5.1Opens a new window
modeling, 2.5.2Opens a new window
queries, 2.4.2Opens a new window
searches, 2.4.2Opens a new window
database caching modes
configuring, 13.5Opens a new window
default database caching mode, 13.5.1Opens a new window
determining which mode to use, 13.5.3Opens a new window
force full database caching mode
about, 13.5.2Opens a new window
verifying, 13.5.4Opens a new window
database monitoring, 1.2.1Opens a new window
diagnostic, 7.1Opens a new window
database performance
comparing, 8.1Opens a new window
degradation over time, 8.1Opens a new window
Database Resource Manager, 10.1.2.1.3Opens a new window, 18.1.3Opens a new window, 18.1.3Opens a new window, 18.4.2Opens a new window
database tuning
performance degradation over time, 8.1Opens a new window
transient performance problems, 9.1Opens a new window
databases
diagnosing and monitoring, 7.1Opens a new window
size, 2.4.2Opens a new window
statistics, 5.1Opens a new window
db block gets from cache statistic, 13.2.2Opens a new window
db file scattered read wait events, 10.2.3Opens a new window, 10.3.3Opens a new window, 10.3.3Opens a new window
actions, 10.3.3.1Opens a new window, 10.3.4.1Opens a new window
db file sequential read wait events, 10.2.3Opens a new window, 10.3.3Opens a new window, 10.3.4Opens a new window
actions, 10.3.4.1Opens a new window
DB time
metric, 7.1.1Opens a new window
statistic, 5.1.1Opens a new window
DB_BLOCK_SIZE initialization parameter, 4.1.1Opens a new window, 17.2.1.2Opens a new window
DB_CACHE_ADVICE parameter, 13.2.4Opens a new window
DB_CACHE_SIZE initialization parameter, 13.3Opens a new window
DB_DOMAIN initialization parameter, 4.1.1Opens a new window
DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter, 10.3.3Opens a new window, 17.2.1.1Opens a new window, 17.2.1.2Opens a new window, 17.2.1.3Opens a new window
DB_KEEP_CACHE_SIZE
initialization parameter, 13.3.6Opens a new window
DB_NAME initialization parameter, 4.1.1Opens a new window
DB_nK_CACHE_SIZE initialization parameter, 13.2.4Opens a new window
DB_RECYCLE_CACHE_SIZE
initialization parameter, 13.3.7Opens a new window
DB_WRITER_PROCESSES initialization parameter, 10.3.9.3.1Opens a new window
DBA_HIST views, 6.2.6Opens a new window
DBA_HIST_WR_CONTROL view
Automatic Workload Repository settings, 6.2.2.4.1Opens a new window
DBA_OBJECTS view, 13.3.5.2Opens a new window
DBIO_EXPECTED parameter, 7.2Opens a new window
DBMS_ADDM package
Automatic Database Diagnostic Monitor, 7.3Opens a new window
DBMS_ADVISOR package
setting DBIO_EXPECTED, 7.2Opens a new window
setups for ADDM, 7.2Opens a new window, 7.2Opens a new window
DBMS_RESULT_CACHE, 15.2.1.2Opens a new window
DBMS_SHARED_POOL package
managing the shared pool, 14.3.5Opens a new window
DBMS_WORKLOAD_REPOSITORY package
managing the Automatic Workload Repository, 6.2.2.1Opens a new window, 6.2.3.1Opens a new window, 6.2.4.1Opens a new window
debugging designs, 2.6.4Opens a new window
default cache, 13.3.1.1Opens a new window
deploying applications, 2.7Opens a new window
design principles, 2.5Opens a new window
designs
debugging, 2.6.4Opens a new window
testing, 2.6.4Opens a new window
validating, 2.6.4Opens a new window
development environments, 2.5.6Opens a new window
diagnostic monitoring, 1.2.1Opens a new window, 7.1Opens a new window
introduction, 7.1Opens a new window
dictionary cache, 8.3.2.14Opens a new window
direct path
read events, 10.3.5Opens a new window
read events actions, 10.3.5.2Opens a new window
read events causes, 10.3.5.1Opens a new window
wait events, 10.3.6Opens a new window
write events actions, 10.3.6.2Opens a new window
write events causes, 10.3.6.1Opens a new window
disks
monitoring operating system file activity, 10.1.2.2Opens a new window

E

EMOpens a new window  ENOpens a new window  ESOpens a new window  EXOpens a new window 
emergencies
performance, 3.2Opens a new window
Emergency Performance Method, 3.2.1Opens a new window
End to End Application Tracing
action and module names, 2.5.6Opens a new window
enqueue
about, 8.3.2.9.2Opens a new window
enqueue wait events, 10.2.3Opens a new window, 10.3.7Opens a new window
actions, 10.3.7.2Opens a new window
statistics, 10.1.3.4.5Opens a new window
estimating workloads, 2.6.2Opens a new window
benchmarking, 2.6.2.2Opens a new window
extrapolating, 2.6.2.1Opens a new window
EXTENT MANAGEMENT LOCAL
creating temporary tablespaces, 4.1.4.2Opens a new window
extrapolating workloads, 2.6.2.1Opens a new window

F

FAOpens a new window  FIOpens a new window  FROpens a new window  FUOpens a new window 
FAST_START_MTTR_TARGET
and tuning instance recovery, 10.4.3Opens a new window
Fast-Start checkpointing architecture, 10.4.2Opens a new window
Fast-Start Fault Recovery, 10.4Opens a new window, 10.4.2Opens a new window
FILESYSTEMIO_OPTIONS initialization parameter, 18.1.1.2Opens a new window
free buffer wait events, 10.2.3Opens a new window, 10.3.9Opens a new window
free lists, 10.3.2.2.1Opens a new window
full table scans, 10.3.5.2.2Opens a new window
function-based indexes, 2.5.3.2.3Opens a new window

H

HAOpens a new window  HOOpens a new window  HWOpens a new window 
hard parsing, 2.5.5Opens a new window
hardware
components, 2.4.1.1Opens a new window
limitations of components, 2.3.3Opens a new window
sizing of components, 2.3.3Opens a new window
HOLD_CURSOR clause, 14.2.6.2Opens a new window
hours of service, 2.4.2Opens a new window
HW enqueue
contention, 10.3.7.2.2Opens a new window

I

IDOpens a new window  IMOpens a new window  INOpens a new window 
idle wait events, 10.3.10Opens a new window
SQL*Net message from client, 10.3.19.1Opens a new window
implementing business logic, 2.4.1.2.2Opens a new window
indexes
adding columns, 2.5.3.1Opens a new window
appending columns, 2.5.3.1Opens a new window
bitmap, 2.5.3.2.2Opens a new window
B-tree, 2.5.3.2.1Opens a new window
column order, 2.5.3.5Opens a new window
costs, 2.5.3.3Opens a new window
creating, 4.2.3Opens a new window
design, 2.5.3Opens a new window
function-based, 2.5.3.2.3Opens a new window
partitioned, 2.5.3.2.4Opens a new window
placement on disk, 17.2.2Opens a new window
reducing I/O, 2.5.3.5Opens a new window
reverse key, 2.5.3.2.5Opens a new window
selectivity, 2.5.3.5Opens a new window
sequences in, 2.5.3.4Opens a new window
serializing in, 2.5.3.4Opens a new window
initialization parameters
CONTROL_FILES, 4.1.1Opens a new window
DB_BLOCK_SIZE, 4.1.1Opens a new window
DB_DOMAIN, 4.1.1Opens a new window
DB_NAME, 4.1.1Opens a new window
OPEN_CURSORS, 4.1.1Opens a new window
PGA_AGGREGATE_TARGET, 4.2.3.1Opens a new window
PROCESSES, 4.1.1Opens a new window
SESSIONS, 4.1.1Opens a new window
STREAMS_POOL_SIZE, 4.1.1Opens a new window, 12.2Opens a new window
In-Memory Column Store
about, 12.4.1Opens a new window
configuring, 12.4Opens a new window
estimating required size, 12.4.3Opens a new window
performance benefits, 12.4.2Opens a new window
sizing, 12.4.4Opens a new window
In-Memory Column Store (IM column store), PrefaceOpens a new window
instance activity
comparing, 8.3.2.6Opens a new window
instance caging, 18.4Opens a new window
instance configuration
initialization files, 4.1.1Opens a new window
performance considerations, 4.1Opens a new window
instance recovery
Fast-Start Fault Recovery, 10.4.2Opens a new window
performance tuning, 10.4Opens a new window
Internet scalability, 2.3.2Opens a new window
I/O
and SQL statements, 10.3.3.4Opens a new window
contention, 10.1.2.2.1Opens a new window, 10.1.3.2Opens a new window, 10.3.3.2Opens a new window, 10.3.15Opens a new window
excessive I/O waits, 10.3.3.2Opens a new window
monitoring, 10.1.2.2Opens a new window
objects causing I/O waits, 10.3.3.5Opens a new window

K

KEOpens a new window 
KEEP buffer pool, 13.3.6Opens a new window
KEEP cache, 13.3.1.1Opens a new window

L

LAOpens a new window  LIOpens a new window  LOOpens a new window  LROpens a new window 
LARGE_POOL_SIZE initialization parameter, 14.4.3Opens a new window
latch contention
library cache latches, 10.2.1.2Opens a new window
shared pool latches, 10.2.1.2Opens a new window
latch free wait events, 10.2.3Opens a new window
actions, 10.3.11.1Opens a new window
latch wait events, 10.3.11Opens a new window
latches, 9.3.7.3Opens a new window
tuning, 1.1.2.3Opens a new window, 10.3.11.3Opens a new window
library cache, 8.3.2.15Opens a new window
latch contention, 10.3.11.3Opens a new window
latch wait events, 10.3.11.1Opens a new window
lock, 10.3.14Opens a new window
pin, 10.3.13Opens a new window
linear scalability, 2.3.3Opens a new window
locks and lock holders
finding, 10.3.7.1Opens a new window
log buffer
space wait events, 10.2.3Opens a new window, 10.3.15Opens a new window
log file
parallel write wait events, 10.3.12Opens a new window
switch wait events, 10.3.16Opens a new window
sync wait events, 10.2.3Opens a new window, 10.3.17Opens a new window
log writer processes
tuning, 17.2.3.2Opens a new window
LOG_BUFFER initialization parameter, 13.4.1Opens a new window
LRU
aging policy, 13.3Opens a new window
latch contention, 10.3.11.3.4Opens a new window

M

MAOpens a new window  MEOpens a new window  MIOpens a new window  MOOpens a new window  MUOpens a new window 
managing the user interface, 2.4.1.2.1Opens a new window
max session memory statistic, 14.4.3Opens a new window
MAX_DISPATCHERS initialization parameter, 4.3.1.1Opens a new window
MAXOPENCURSORS clause, 14.2.6.2Opens a new window
memory
hardware component, 2.4.1.1.2Opens a new window
PGA statistics, 8.3.2.8Opens a new window
statistics, 8.3.2.16Opens a new window
memory allocation
importance, 11.1Opens a new window
tuning, 12.2.5Opens a new window
metrics, 6.1Opens a new window
migrated rows, 10.2.4.3Opens a new window
mirroring
redo logs, 17.2.3.3Opens a new window
modeling
conceptual, 3.1.2Opens a new window
data, 2.5.2Opens a new window
workloads, 2.6.3Opens a new window
monitoring
diagnostic, 1.2.1Opens a new window
multiple buffer pools, 13.3Opens a new window

N

NAOpens a new window  NEOpens a new window 
NAMESPACE column
V$LIBRARYCACHE view, 14.3.1.1.1Opens a new window
network
hardware component, 2.4.1.1.4Opens a new window
speed, 2.4.2Opens a new window
network communication wait events, 10.3.19Opens a new window
db file scattered read wait events, 10.3.3Opens a new window
db file sequential read wait events, 10.3.3Opens a new window, 10.3.4Opens a new window
SQL*Net message from Dblink, 10.3.19.2Opens a new window
SQL*Net more data to client, 10.3.19.3Opens a new window

O

OBOpens a new window  OPOpens a new window  OROpens a new window 
object-orientation, 2.5.7Opens a new window
OPEN_CURSORS initialization parameter, 4.1.1Opens a new window
operating system
data cache, 18.1.1Opens a new window
monitoring disk I/O, 10.1.2.2Opens a new window
optimization
described
optimizer
introduction, 1.1.3.1Opens a new window
query, 1.1.3.1Opens a new window
Oracle CPU statistics, 10.1.2.1.3Opens a new window
Oracle Enterprise Manager
advisors, 1.2.1Opens a new window
Performance page, 1.2.1Opens a new window
Oracle Forms
control of parsing and private SQL areas, 14.2.6.5Opens a new window
Oracle Managed Files, 17.2.5Opens a new window
tuning, 17.2.5Opens a new window
Oracle Orion
calibration tool parameters, 17.4.4Opens a new window
command-line options, 17.4.4Opens a new window
Oracle performance improvement method, 3.1Opens a new window
steps, 3.1.1Opens a new window

P

PAOpens a new window  PCOpens a new window  PEOpens a new window  PGOpens a new window  PHOpens a new window  PROpens a new window 
package
DBMS_RESULT_CACHE, 15.2.1.2Opens a new window
page table, 18.4.1.1.2Opens a new window
paging, 18.4.1.2Opens a new window
reducing, 12.2.4.1Opens a new window
PARALLEL clause
CREATE INDEX statement, 4.2.3Opens a new window
parameter
RESULT_CACHE_MAX_SIZE, 15.2.1.1Opens a new window
RESULT_CACHE_MODE, 15.2.3Opens a new window
parameters
initialization, 8.3.3.1Opens a new window
parsing
hard, 2.5.5Opens a new window
Oracle Forms, 14.2.6.5Opens a new window
Oracle precompilers, 14.2.6.2Opens a new window
reducing unnecessary calls, 14.2.6Opens a new window
soft, 2.5.5Opens a new window
partitioned indexes, 2.5.3.2.4Opens a new window
PCTFREE parameter, 4.2Opens a new window, 10.2.4.3Opens a new window
PCTUSED parameter, 10.2.4.3Opens a new window, 10.2.4.3Opens a new window
performance
emergencies, 3.2Opens a new window
improvement method, 3.1Opens a new window
improvement method steps, 3.1.1Opens a new window
mainframe, 18.2.3Opens a new window
monitoring memory on Windows, 18.4.1.1.1Opens a new window
tools for diagnosing and tuning, 1.2Opens a new window
UNIX-based systems, 18.2.1Opens a new window
Windows, 18.2.2Opens a new window
Performance Hub active reports
about, 6.4.1Opens a new window
generating, 6.4Opens a new window, 6.4.3Opens a new window
performance problems
transient, 9.1Opens a new window
performance tuning
Fast-Start Fault Recovery, 10.4Opens a new window
instance recovery, 10.4Opens a new window
FAST_START_MTTR_TARGET, 10.4.2Opens a new window
setting FAST_START_MTTR_TARGET, 10.4.3Opens a new window
using V$INSTANCE_RECOVERY, 10.4.2.3Opens a new window
PGA_AGGREGATE_TARGET initialization parameter, 4.1.1Opens a new window, 4.2.3.1Opens a new window, 16.2.1Opens a new window, 18.1.2.2Opens a new window
physical reads from cache statistic, 13.2.2Opens a new window
PRIVATE_SGA variable, 14.4.4Opens a new window
proactive monitoring, 1.1.2.4.1Opens a new window
processes
scheduling, 18.4.1.4.1Opens a new window
PROCESSES initialization parameter, 4.1.1Opens a new window
program global area (PGA)
direct path read, 10.3.5Opens a new window
direct path write, 10.3.6Opens a new window
shared servers, 14.4.1Opens a new window
programming languages, 2.5.6Opens a new window

Q

QUOpens a new window 
queries
data, 2.4.2Opens a new window
query optimizer, 1.1.3.1Opens a new window
See optimizer

R

RDOpens a new window  REOpens a new window  ROOpens a new window 
rdbms ipc reply wait events, 10.3.18Opens a new window
read consistency, 10.2.4.2Opens a new window
read wait events
direct path, 10.3.5Opens a new window
scattered, 10.3.3Opens a new window
RECYCLE cache, 13.3.1.1Opens a new window
REDO BUFFER ALLOCATION RETRIES statistic, 13.4.2Opens a new window
redo logs, 4.1.3Opens a new window
buffer size, 10.3.15Opens a new window
mirroring, 17.2.3.3Opens a new window
placement on disk, 17.2.3.2Opens a new window
sizing, 4.1.3Opens a new window
space requests, 10.2.4.1Opens a new window
reducing
contention with dispatchers, 4.3.1.1Opens a new window
paging and swapping, 12.2.4.1Opens a new window
RELEASE_CURSOR clause, 14.2.6.2Opens a new window
resources
allocation, 2.4.1.2.3Opens a new window, 2.5.6Opens a new window
bottlenecks, 10.3.19.1.2Opens a new window
wait events, 10.3.4Opens a new window
response time, 2.4.2Opens a new window
reverse key indexes, 2.5.3.2.5Opens a new window
rollout strategies
big bang approach, 2.7.1Opens a new window
trickle approach, 2.7.1Opens a new window
row cache objects, 10.3.11.3.6Opens a new window

S

SAOpens a new window  SCOpens a new window  SEOpens a new window  SGOpens a new window  SHOpens a new window  SIOpens a new window  SNOpens a new window  SOOpens a new window  SQOpens a new window  STOpens a new window  SWOpens a new window  SYOpens a new window 
sar UNIX command, 18.4.1.1.1Opens a new window
scalability, 2.3.1Opens a new window
factors preventing, 2.3.3Opens a new window, 2.3.3Opens a new window
Internet, 2.3.2Opens a new window
linear, 2.3.3Opens a new window
scattered read wait events, 10.3.3Opens a new window
actions, 10.3.3.1Opens a new window
segment-level statistics, 10.1.3.5Opens a new window
selectivity
ordering columns in an index, 2.5.3.5Opens a new window
sequential read wait events
actions, 10.3.4.1Opens a new window
service hours, 2.4.2Opens a new window
session memory statistic, 14.4.3Opens a new window
SESSIONS initialization parameter, 4.1.1Opens a new window
SGA_TARGET initialization parameter, 4.1.1Opens a new window
and Automatic Shared Memory Management, 12.1.2.1Opens a new window
automatic memory management, 12.1Opens a new window
shared pool contention, 10.3.11.3Opens a new window
shared server
performance issues, 4.3Opens a new window
reducing contention, 4.3Opens a new window
tuning, 4.3Opens a new window
tuning memory, 14.4.1Opens a new window
SHARED_POOL_SIZE initialization parameter, 14.3.1.4Opens a new window, 14.3.1.5Opens a new window
SHOW SGA statement, 12.2.4.2.1Opens a new window
sizing redo logs, 4.1.3Opens a new window
snapshots
about, 6.1.2Opens a new window
soft parsing, 2.5.5Opens a new window
software
components, 2.4.1.2Opens a new window
sort areas
tuning, 16.1.1Opens a new window
SQL statements
waiting for I/O, 10.3.3.4Opens a new window
SQL Tuning Advisor, 1.2.1Opens a new window
SQL*Net
message from client idle events, 10.3.19.1Opens a new window
message from dblink wait events, 10.3.19.2Opens a new window
more data to client wait events, 10.3.19.3Opens a new window
ST enqueue
contention, 10.3.7.2.1Opens a new window
statistics
and STATISTICS_LEVEL initialization parameter, 1.2Opens a new window
baselines, 6.1Opens a new window
consistent gets from cache, 13.2.2Opens a new window
databases, 5.1Opens a new window
db block gets from cache, 13.2.2Opens a new window
dictionary cache, 8.3.2.14Opens a new window
gathering, 5.1Opens a new window
instance activity, 8.3.2.6Opens a new window
I/O, 8.3.2.7Opens a new window
latch, 8.3.2.11Opens a new window
library cache, 8.3.2.15Opens a new window
max session memory, 14.4.3Opens a new window
memory, 8.3.2.16Opens a new window
operating system
comparing, 8.3.2.2Opens a new window
PGA memory, 8.3.2.8Opens a new window
physical reads from cache, 13.2.2Opens a new window
segment, 8.3.2.12Opens a new window, 8.3.2.13Opens a new window
segment-level, 10.1.3.5Opens a new window
service, 8.3.2.4Opens a new window
session memory, 14.4.3Opens a new window
shared server processes, 4.3.2Opens a new window
SQL, 8.3.2.5Opens a new window
time model, 5.1.1Opens a new window, 8.3.2.1Opens a new window
undo, 8.3.2.10Opens a new window
waits, 8.3.2.9Opens a new window
STATISTICS_LEVEL initialization parameter, 5.2.2Opens a new window, 10.1.3.1Opens a new window
and Automatic Workload Repository, 6.2.1Opens a new window
enabling automatic database diagnostic monitoring, 7.2Opens a new window
settings for statistic gathering, 1.2Opens a new window
STREAMS_POOL_SIZE initialization parameter, 4.1.1Opens a new window, 12.2Opens a new window
striping
manual, 17.2.2Opens a new window
swapping, 18.4.1.1.1Opens a new window, 18.4.1.2Opens a new window
reducing, 12.2.4.1Opens a new window
switching processes, 18.4.1.4.1Opens a new window
system architecture, 2.4Opens a new window
configuration, 2.4.2Opens a new window
hardware components, 2.4.1.1Opens a new window
CPUs, 2.4.1.1.1Opens a new window
I/O subsystems, 2.4.1.1.3Opens a new window
memory, 2.4.1.1.2Opens a new window
networks, 2.4.1.1.4Opens a new window
software components, 2.4.1.2Opens a new window
data and transactions, 2.4.1.2.4Opens a new window
implementing business logic, 2.4.1.2.2Opens a new window
managing the user interface, 2.4.1.2.1Opens a new window
user requests and resource allocation, 2.4.1.2.3Opens a new window
System Global Area tuning, 12.2.4.2Opens a new window

T

TAOpens a new window  TEOpens a new window  THOpens a new window  TIOpens a new window  TMOpens a new window  TOOpens a new window  TROpens a new window  TUOpens a new window  TXOpens a new window 
tables
creating, 4.2Opens a new window
design, 2.5.3Opens a new window
full scans, 10.3.5.2.2Opens a new window
placement on disk, 17.2.2Opens a new window
setting storage options, 4.2Opens a new window
tablespaces, 4.1.4Opens a new window
creating, 4.1.4Opens a new window, 4.1.4.2Opens a new window
temporary, 4.1.4Opens a new window, 4.1.4.2Opens a new window
temporary tablespaces, 4.1.4Opens a new window
creating, 4.1.4.2Opens a new window
testing designs, 2.6.4Opens a new window
thrashing, 18.4.1.2Opens a new window
time model statistics, 5.1.1Opens a new window
comparing, 8.3.2.1Opens a new window
TM enqueue contention, 10.3.7.2.3Opens a new window
tools for performance tuning, 1.2Opens a new window
Top Java
Active Session History report, 9.3.5Opens a new window
top PL/SQL
Active Session History report, 9.3.4Opens a new window
Top Sessions
Active Session History report, 9.3.6Opens a new window
Top SQL
Active Session History report, 9.3.3Opens a new window
transactions and data, 2.4.1.2.4Opens a new window
trickle rollout strategy, 2.7.1Opens a new window
tuning
and bottleneck elimination, 1.1.2.4.2Opens a new window
and proactive monitoring, 1.1.2.4.1Opens a new window
latches, 1.1.2.3Opens a new window, 10.3.11.3Opens a new window
resource contention, 10Opens a new window
shared server, 4.3Opens a new window
sorts, 16.1.1Opens a new window
System Global Area (SGA), 12.2.4.2Opens a new window
TX enqueue contention, 10.3.7.2.4Opens a new window

U

UNOpens a new window  USOpens a new window  UTOpens a new window 
undo management, automatic mode, 4.1.2Opens a new window
UNDO TABLESPACE clause, 4.1.2Opens a new window
UNDO_MANAGEMENT initialization parameter, 4.1.1Opens a new window, 4.1.2Opens a new window
UNDO_TABLESPACE initialization parameter, 4.1.1Opens a new window
UNIX system performance, 18.2.1Opens a new window
user global area (UGA)
shared servers, 4.3Opens a new window, 14.4.1Opens a new window
user requests, 2.4.1.2.3Opens a new window
users
interaction method, 2.4.2Opens a new window
interfaces, 2.5.6Opens a new window
location, 2.4.2Opens a new window
network speed, 2.4.2Opens a new window
number of, 2.4.2Opens a new window
requests, 2.5.6Opens a new window
response time, 2.4.2Opens a new window
UTLCHN1.SQL script, 10.2.4.3Opens a new window

V

VAOpens a new window  VIOpens a new window  VMOpens a new window 
V$ACTIVE_SESSION_HISTORY view, 5.1.2Opens a new window, 10.1.3.3Opens a new window
V$BH view, 13.3.5Opens a new window
V$BUFFER_POOL_STATISTICS view, 13.3.4Opens a new window
V$DB_CACHE_ADVICE view, 13.2.1Opens a new window, 13.2.2Opens a new window, 13.2.4Opens a new window, 13.2.5Opens a new window, 13.3.3Opens a new window
V$EVENT_HISTOGRAM view, 10.1.3.3Opens a new window
V$FILE_HISTOGRAM view, 10.1.3.3Opens a new window
V$JAVA_LIBRARY_CACHE_MEMORY view, 14.3.1.2.3Opens a new window
V$JAVA_POOL_ADVICE view, 14.3.1.2.3Opens a new window
V$LIBRARY_CACHE_MEMORY view, 14.3.1.2.2Opens a new window
V$LIBRARYCACHE view
NAMESPACE column, 14.3.1.1.1Opens a new window
V$QUEUE view, 4.3.2Opens a new window
V$ROWCACHE view
performance statistics, 14.3.1.3Opens a new window
V$RSRC_CONSUMER_GROUP view, 10.1.2.1.3Opens a new window
V$SESS_TIME_MODEL view, 5.1.1Opens a new window, 10.1.3.3Opens a new window
V$SESSION view, 10.1.3.3Opens a new window, 10.1.3.4Opens a new window, 10.3Opens a new window
V$SESSION_EVENT view, 10.1.3.3Opens a new window, 10.3Opens a new window
V$SESSION_WAIT view, 10.1.3.3Opens a new window, 10.3Opens a new window
V$SESSION_WAIT_CLASS view, 10.1.3.3Opens a new window
V$SESSION_WAIT_HISTORY view, 10.1.3.3Opens a new window, 10.1.3.3Opens a new window, 10.3Opens a new window
V$SESSTAT view, 10.1.2.1.3Opens a new window, 14.4.3Opens a new window
V$SHARED_POOL_ADVICE view, 14.3.1.2.1Opens a new window
V$SHARED_POOL_RESERVED view, 14.3.6.1Opens a new window
V$SYS_TIME_MODEL view, 5.1.1Opens a new window, 10.1.3.3Opens a new window
V$SYSSTAT view
redo buffer allocation, 13.4.2Opens a new window
using, 13.2.2Opens a new window
V$SYSTEM_EVENT view, 10.1.3.3Opens a new window, 10.3Opens a new window
V$SYSTEM_WAIT_CLASS view, 10.1.3.3Opens a new window
V$TEMP_HISTOGRAM view, 10.1.3.3Opens a new window
V$UNDOSTAT view, 4.1.2Opens a new window
V$WAITSTAT view, 10.1.3.4Opens a new window
validating designs, 2.6.4Opens a new window
views, 2.5.4Opens a new window
DBA_HIST, 6.2.6Opens a new window
vmstat UNIX command, 18.4.1.1.1Opens a new window

W

WAOpens a new window  WIOpens a new window  WOOpens a new window 
wait events, 5.1.3Opens a new window
buffer busy waits, 10.3.2Opens a new window
classes, 5.1.3Opens a new window, 10.1.3.2Opens a new window
comparing, 8.3.2.3Opens a new window
contention wait events, 10.3.11Opens a new window
direct path, 10.3.6Opens a new window
enqueue, 10.3.7Opens a new window
free buffer waits, 10.3.9Opens a new window
idle wait events, 10.3.10Opens a new window
latch, 10.3.11Opens a new window
library cache latch, 10.3.11.1Opens a new window
log buffer space, 10.3.15Opens a new window
log file parallel write, 10.3.12Opens a new window
log file switch, 10.3.16Opens a new window
log file sync, 10.3.17Opens a new window
network communication wait events, 10.3.19Opens a new window
rdbms ipc reply, 10.3.18Opens a new window
resource wait events, 10.3.4Opens a new window
Windows performance, 18.2.2Opens a new window
workloads, 2.6.2Opens a new window, 2.6.2.1Opens a new window, 2.6.2.2Opens a new window, 2.6.3Opens a new window, 2.6.4Opens a new window
Previous PageOpens a new window
Next Page