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

In This Chapter

Setting Operating-System Shared-Memory Configuration Parameters

Setting Database Server Shared-Memory Configuration Parameters

Setting SQL Statement Cache Parameters

Setting Up Shared Memory

Turning Residency On or Off for Resident Shared Memory

Adding a Segment to the Virtual Portion of Shared Memory

Monitoring 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