Oracle Database 10g Performance Tuning Tips & Techniques

Index

References to figures are in italics.

<> operators, 40

!= operators, 40

80/20 Rule, 321–322

A

access methods, hints, 283

active transaction management, 475–476

ADDM. See Automatic Database Diagnostic Monitor (ADDM)

alerts, server-generated, 6–7

aliases, and hints, 287

ALL_ROWS hint, 289

allocation units (AUs), 93

APPEND hint, 304

Applications database, sizing, 156–157

AS COMPRESSED BACKUPSET argument, 15

ASM. See Automatic Storage Management (ASM)

ASM instances, 5, 79–80

ASMB, 91

ASMLib, 83

ASMM. See Automatic Shared Memory Management (ASMM)

ASSM. See Automatic Segment Space Management (ASSM)

associative arrays, 464–467

Automatic Database Diagnostic Monitor (ADDM), 8–10, 759–761

Automatic Segment Space Management (ASSM), 76, 108

Automatic ...