Index A B

Page 233

Index

References to figures and illustrations are in italics.

A

accent-insensitive searching, 172–173

Active Session History (ASH), 48

ADDM. See Automatic Database Diagnostic Monitor

Advanced Queuing, 196

aggregates

removal of restrictions on number of, 209

using in returning clause, 207–208

alerts

alert log viewer, 230

nonthreshold, 60

server-generated, 44, 59–61, 220

threshold, 60

ALL_MP_GRAPH_WORKSPACES, 196

ALL_MP_PARENT_WORKSPACES, 196

alter database archivelog command, 76

AQ. See Advanced Queuing

ARB, 232

ASM. See Automatic Storage Management

ASMB, 232

auditing

DML statements, 72

Fine-grained, 71–72

new columns in DBA_AUDIT_TRAIL, 70

view changes, 71–72

authentication, 72

Automatic Database Diagnostic Monitor, 53–55

Automatic Storage Management, 9, 223

addressing ASM disks, 12

ASM instance, 10–11

and data dictionary views, 12–13

features, 9–10

setting up ASM disks, 11–12

Automatic Workload Repository, 15, 43, 44

Active Session History (ASH), 48

base statistics, 48

clients, 48

infrastructure, 45

in-memory statistics collection area, 44–45

MMML, 50

MMON, 50

reporting from, 50

usage metrics, 48–49

workload repository (WR), 45–48

AWR. See Automatic Workload Repository

B

backups, 76–77

backup as copy command, 83–84

backup current controlfile, 85

backup file image copies, 84

compressing, 90

controlling backup rates and duration, 91–92

incremental, 87–89