Index_L

---

L

Latches, 611–24

defined, 611

latch misses, spins, and sleeps, 611–14

latch performance views, 614–15

latches in real time, 615–16

most significant latches, 616–24

database buffer cache, 617–20

library cache latches, 621–23

metadata cache latches, 623

network and database connection latches, 624

redo log buffer, 623

shared pool, 620–21

Low level physical tuning, 467–88

block and extent tuning, 471

block concurrency, 483–84

choosing block size, 471–73

extent level storage parameters, 485–88

different cache recently used lists, 487–88

managing concurrency, 487

minimizing rollback resizing, 487

minimum and maximum extents, 486

setting extent sizes, 485–86

variable extent sizes, 486–87

high water mark, 467–68

physical block structure, 473–82

parts of a block, 474–76

PCTFREE settings, 482

space management, 476–82

row chaining and row migration, 469–70

space used, 468–69

types of objects, 470–71

---