Introduction

The Database Server

Installing and Configuring the Database Server

Configuration Parameters

Client/Server Communications

Initializing the Database Server

Security

Disk, Memory, and Process Management

Virtual Processors and Threads

Managing Virtual Processors

Shared Memory

Managing Shared Memory

Data Storage

In This Chapter

Physical and Logical Units of Storage

Chunks

Pages

Blobpages

Sbpages

Extents

Dbspaces

Blobspaces

Sbspaces

Temporary Sbspaces

Extspaces

Databases

Tables

Table Types for Dynamic Server

Standard Permanent Tables

RAW Tables

Temp Tables

Properties of Table Types

Temporary Tables

Tblspaces

Table Fragmentation and Data Storage

Amount of Disk Space Needed to Store Data

Disk-Layout Guidelines

Sample Disk Layouts

Logical-Volume Manager

Managing Disk Space

Logging and Log Administration

Logging

Managing the Database-Logging Mode

Logical Log

Managing Logical-Log Files

Physical Logging, Checkpoints, and Fast Recovery

Managing the Physical Log

Fault Tolerance

Mirroring

Using Mirroring

High-Availability Data Replication (Enterprise/Workgroup Editions)

Using High-Availability Data Replication (Enterprise/Workgroup Editions)

Consistency Checking

Distributed Data

Multiphase Commit Protocols

Recovering Manually from Failed Two-Phase Commit

Appendixes

Appendix. Accessibility

Notices

Index