Using Oracle Blocks Efficiently

Objectives

Database Storage Hierarchy

Allocating an Extent

Avoiding Dynamic Allocation

Avoiding Dynamic Allocation Disadvantages

Pros and Cons of Large Extents

Database Block Size

DB_BLOCK_SIZE

Small Block Size Pros and Cons

Large Block Size Pros and Cons

PCTFREE and PCTUSED

Guidelines

Migration and Chaining

Detecting Migration and Chaining

Selecting Migrated Rows

Eliminating Migrated Rows

The High-Water Mark

Table Statistics

The DBMS_SPACE Package

Index Reorganization

Monitoring Indexes

Summary