Oracle Parallel Processing
Oracle Parallel Processing By Tushar Mahapatra, Sanjay Mishra
August 2000
Pages: 288

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  1. Overview

    1. Chapter 1 Introduction

      1. About Parallel Processing
      2. Parallel Processing for Databases
      3. Parallel Processing in Oracle
      4. Overhead for Oracle Parallel Processing
      5. Requirements for Oracle's Parallel Features

    2. Chapter 2 Architectures for Parallel Processing

      1. Hardware Architectures
      2. High-Speed Interconnect
      3. Software Architectures of Parallel Database Systems
      4. Oracle's Parallel Processing Architecture

  2. Oracle Parallel Execution

    1. Chapter 3 Parallel Execution Concepts

      1. What Is Parallel SQL?
      2. How Parallel Execution Works

    2. Chapter 4 Using Parallel Execution

      1. Parallel Query
      2. Parallel DML
      3. Parallel DDL
      4. Parallel Data Loading
      5. Parallel Recovery
      6. Parallel Replication Propagation

    3. Chapter 5 Monitoring and Tuning Parallel Execution

      1. Tuning Overview
      2. Dynamic Performance Views
      3. Using EXPLAIN PLAN to View Parallel Execution
      4. Tuning Tips for Parallel Execution
      5. Automatic Tuning of Parallel Execution in Oracle8i

  3. Oracle Parallel Server

    1. Chapter 6 Oracle Parallel Server Architecture

      1. OPS and Oracle Instances
      2. Synchronization Between Instances
      3. OPS Impact on Database Files
      4. Integrated Distributed Lock Manager
      5. Group Membership Service
      6. Rollback Segments in OPS

    2. Chapter 7 Administering an OPS Database

      1. Creating an OPS Database
      2. Starting and Stopping an OPS Database
      3. Managing Instance Groups
      4. Backing Up an OPS Database
      5. Recovering an OPS Database

    3. Chapter 8 Locking Mechanisms in OPS

      1. Cache Coherency
      2. Lock Types in OPS
      3. Lock Modes
      4. Parallel Cache Management
      5. PCM Lock Types
      6. PCM Lock Allocation Parameters and Verification
      7. PCM Lock Allocation Guidelines
      8. Non-PCM Locks

    4. Chapter 9 Storage Management in OPS

      1. Using Free Lists and Free List Groups
      2. The PCTFREE Parameter: Reserving Free Space
      3. Using Reverse Key Indexes

    5. Chapter 10 Monitoring and Tuning OPS

      1. OPS Performance Views
      2. Dynamic Performance Views
      3. Monitoring PCM Locking
      4. Monitoring Overall Statistics
      5. Monitoring and Tuning IDLM
      6. Oracle Performance Manager

    6. Chapter 11 Partitioning for OPS

      1. When Is Partitioning Needed?
      2. Partitioning Techniques
      3. Changing Your Partitioning Scheme

    7. Chapter 12 Application Failover

      1. Maintaining a Failover Database
      2. Planning for Failover with OPS
      3. Failover Complexity
      4. Failover Methods

    8. Chapter 13 Parallel Execution in OPS

      1. How Parallel Execution Works with OPS
      2. Disk Affinity
      3. Instance Groups for Parallel Execution

  1. Appendix A Appendix: Case Studies

    1. Application Suitability

    2. Case Study 1: An OLTP Application on an SMP Platform

    3. Case Study 2: An OLTP Application on a Cluster

    4. Case Study 3: A DSS Application on an MPP Platform

  2. Colophon

Return to Oracle Parallel Processing