Index_M

---

M

Maintainability, 9

Manageability

of business requirements, 8–9

defined, 8

Massively parallel processing (MPP), 20

Master instances

current, 362, 369

previous, 362, 369

Materialized views, 277–80

advantage, 278

defined, 277–78

query write, 280

in RAC environment, 280

refresh process, 279–80

MAX_COMMIT_PROPAGATION_DELAY

parameter, 381

Maximum availability architecture (MAA), 435–36

defined, 435

obtaining, 436

Mean time between failures (MTBF), 13

Mean time to recover (MTTR), 6, 7

Media failures, 498–504

database operation after, 498

database recovery, 500

data file recovery, 499

defined, 498

reasons for, 498

recovery, 499–504

recovery steps, 502–4

tablespace recovery, 499–500

thread recovery, 500–502

write, 499

See also Failure(s)

Media management layer (MML), 465

Media recovery (MR), 503

Memory management, 587–98

DB_CACHE_ADVICE, 592

DB_CACHE_SIZE, 591–92

DB_KEEP_CACHE_SIZE, 593

DB_RECYCLE_CACHE_SIZE, 594

OPTIMIZER_INDEX_CACHING, 597–98

OPTIMIZER_INDX_COST_ADJ, 596

PGA_AGGREGATE_TARGET, 595

SGA_MAX_SIZE, 596

SHARED_POOL, 587

V$BUFFER_POOL, 594

V$DB_CACHE_ADVICE, 592–93

V$LIBRARYCACHE, 590–91

V$LIBRARY_CACHE_MEMORY, 590

V$PGASTAT, 595

V$PGA_TARGET_ADVICE, 595–96

V$SHARED_POOL_ADVICE, 588–90

See also Instance tuning

Merge partition, 274

Methodology, 572–76

application tier, 573

quadrants, 574–76

steps, 573

See also Performance tuning

Migration, 439–56

analysis process, 440–41

capacity planning, 444–50

cost-benefit analysis, 442–43

data export and, 453

introduction, 439–40

preparation phase, 443–44

from single instance to RAC, 451–55

single-instance vs. multi-instance configurations, 450–51

work plan checklist, 746–49

Mini-checkpoint, 478

Mirroring, 52–53

advantages, 53

defined, 52

at storage subsystem level, 56

Monitors, 124, 426

Most recently used (MRU) area, 70, 71, 72

Move partition, 275

Multi-instance configuration, 324

instance parameter files, 324

single-instance configuration vs., 450–51

Multi-instance transaction behavior, 182–204

cache fusion, 183–98

parse operation, 198–204

Multiprocessing systems, 19–23

loosely coupled, 25–36

tightly coupled, 25–36

---