Home | Previous Page | Next Page Disk, Memory, and Process Management >

Data Storage

In This Chapter

Overview of Data Storage

Physical Units of Storage

Chunk Size, Number, and Names

Disk Allocation for Chunks

Unbuffered or Buffered Disk Access on UNIX

Disabling I/O Errors

Logical Units of Storage

Control of Where Data Is Stored

Temporary Dbspaces

Advantages of Using Temporary Dbspaces

Temporary Dbslices

Scratch and Temp Tables

Raw Permanent Tables

Static Permanent Tables

Operational Permanent Tables

Standard Permanent Tables

External Tables

Rollback of Operational and Raw Tables

Switching Between Table Types

Temporary Tables

Storage of Temporary Tables

Extent Interleaving

Table Fragmentation and Data Storage

Amount of Disk Space Needed to Store Data

Size of the Root Dbspace

Physical and Logical Logs

Temporary Tables

Control Information

Amount of Space That Databases Require

Disk-Layout Guidelines

Dbspace and Chunk Guidelines

Strive to Associate Partitions with Chunks

Mirror Critical Data Dbspaces

Spread Temporary Storage Space Across Multiple Disks

Move the Logical and Physical Logs from the Root Dbspace

Consider Account Backup-and-Restore Performance

Table-Location Guidelines

Isolate High-Use Tables

Consider Mirroring

Group Tables with Backup and Restore in Mind

Place High-Use Tables on Middle Partition of Disk

Optimize Table-Extent Sizes

Sample Disk Layouts

Sample Layout When Performance Is Highest Priority

Sample Layout When Availability Is Highest Priority

Logical-Volume Manager

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]