Index

---

References to figures are in italics.

A

active session history, 74-75

ACTIVE_INSTANCE_COUNT, 142

ADDM. See Automatic Database Diagnostic Monitor

advanced queuing, 358

See also Streams

Advisor Central, 76

Memory Advisor and ASMM, 78-80

MTTR Advisor, 81

Segment Advisor, 81-82

SQL Access Advisor, 77

SQL Tuning Advisor, 76-77

Undo Management Advisor, 82

AFFIRM attribute, 223

ARC attribute, 221-222

architecture and availability, 34-48

archivelog backup, 318-320

archiving, 15

in an ASM environment, 152-153

in a cluster file system environment, 152

enabling in a RAC database, 153-156

gap detection and resolution, 230-231

with RAW devices as the file system, 151

ASH. See active session history

ASM. See Automatic Storage Management

ASMM. See automatic shared memory management

Automatic Database Diagnostic Monitor, 10, 23

DB time model, 75

and Enterprise Manager, 72-73

modes, 70

overview, 70

sources for, 73-75

viewing past ADDM runs, 72-73

viewing the ADDM reports, 70-75

wait events and active session history, 74-75

automatic shared memory management, 78

ceilings and floors, 78-79

non-ASMM tunable SGA components, 79

Automatic Storage Management, 11, 104

archiving, 152-153

background processes, 87

concepts, 83-87

creating ASM disk groups using the DBCA, 89-91

creating the ASM instance, 88-89

disk groups, 83-84, 89-91, 171

failure groups, 85

file size limits, 85-86

implementing, 87-91

instances, 192-193

managing ASM environments, 170-171

managing with Enterprise Manager, 91-95

metadata, 95

overview, 83

and RAC, 87

rebalancing operations, 86-87

stripe and mirror everything (SAME), 84-85

using for Cluster-Ready Services, 115-116, 117

Automatic Workload Repository, 10

command-line API for, 64

creating baselines for comparing workloads, 66-67

exploring (workshop), 67-69

interpreting the AWR report output, 64-65

main report, 65

monitoring RAC metrics, 147-148

overview, 63-64

RAC statistics, 65

viewing an AWR report, 64

availability

and architecture, 34-48

and partitioning, 42

test and development, 7-8

user-defined, 7

AWR. See Automatic Workload Repository

---