Index_B

---

B

Background processes, 82–91

archive, 88–89

block server, 348

checkpoint, 86–87

database writer (DBWR), 72, 84–86

data guard, 91

description, 346

DIAG, 128

dispatcher, 90

file mapping monitor, 90–91

illustrated, 83

list of, 83

lock (LCK), 128

lock manager server, 89

log writer (LGWR), 87–88

on multiple instances, 125

process monitor (PMON), 84

queue monitor, 90

in RAC, 124–28

recovery, 90

snapshot, 89

system monitor (SMON), 84

Backup(s), 458–71

full offline, 459–61

hot, 461–63

options, 459

processes, 459

strategies, 459–71

strategy, 471

summary data, 470

verification, 463

BIGFILE tablespace, 95–96

Bind variables, 583, 584

Bitmap indexes, 248–49

for data warehousing applications, 249

defined, 249

size, 248

uses, 248

See also Indexes; indexing

Bitmap join indexes, 249–50

defined, 249

uses, 250

Block header, 104–5

cache layer, 104

information, 350

transaction layer, 104–5

See also Data blocks

Block(s)

availability, 497

data, 103–7

defers, ratio, 647

pinged, 353

pinged per data file, 361

Block written record (BWR), 139

B-tree indexes, 242–44

block layout, 244

compressed, 248

defined, 242

illustrated, 242

leaf block structure, 243

performance benefits, 244

in RAC environment, 244

See also Indexes; indexing

Buffers

busy due to global cache, 643

busy wait, 624–25

cache, chains, 626

cache, LRU chain, 626

default pool size, 591–92

false ping readings, 359

keep pool size, 593

recycle pool size, 594

Business requirements, 4–14

analyzing, 444

auditability, 8

availability, 10–13

defined, 4

evolution, 14

illustrated, 5

manageability and maintainability, 8–9

portability, 5–6

recoverability, 6–7

business requirement analysis, 444

for enterprise system, 450

illustrated, 450

performance and, 447

scaling measurement, 449–50

throughput, 445–47

usage pattern change and, 450

---