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

In This Chapter

Shared Memory

Shared-Memory Use

Shared-Memory Allocation

Shared-Memory Size

Action to Take If SHMTOTAL Is Exceeded

Processes That Attach to Shared Memory

Resident Shared-Memory Segments

Resident Portion of Shared Memory

Virtual Portion of Shared Memory

Communications Portion of Shared Memory (UNIX)

Virtual-Extension Portion of Shared Memory

Concurrency Control

Database Server Thread Access to Shared Buffers

Flushing Data to Disk

Buffering Large-Object Data

Memory Use on 64-Bit Platforms

Managing Shared Memory

Data Storage

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