Contents

Title and Copyright Information

List of Figures

List of Tables

Send Us Your Comments

Preface

Part I Introduction to Deployment in Real Application Clusters

1 Introduction to Application Deployment for Real Application Clusters

Taking Full Advantage of Oracle9i Features

Implementing Oracle9i Features with Real Application Clusters

Storage in Real Application Clusters

High Availability and Failover in Real Application Clusters

The Shared Server in Real Application Clusters

Connection Load Balancing

Transparent Application Failover in Real Application Clusters

PL/SQL in Real Application Clusters

Recovery Manager (RMAN) in Real Application Clusters

2 Application Deployment in Real Application Clusters

Deployment Strategies for Real Application Clusters-Based Applications

Deploying E-Commerce Applications with Real Application Clusters

Flexible Implementation with Cache Fusion

Deploying Data Warehouse Applications with Real Application Clusters

Speed-Up for Data Warehouse Applications on Real Application Clusters

Dynamic Parallel-Aware Query Optimization

Deploying Internet-Based Applications

Application Performance in Real Application Clusters

Administrative Aspects of System Scalability for Real Application Clusters

Part II Deployment and Performance in Real Application Clusters

3 Database Deployment Techniques in Real Application Clusters

Principles of Database Deployment for Real Application Clusters

Tablespace Use in Real Application Clusters

Object Creation and Performance in Real Application Clusters

Object Partitioning

Using Sequence Numbers in Real Application Clusters

Detecting Global Conflicts for Sequences

Using Database Tables to Generate Sequence Numbers

Application Tuning Recommendations for Real Application Clusters

Query Tuning Tips

Transaction Processing Tips

Advanced Queuing and Real Application Clusters

Conclusions and a Summary of Guidelines

4 Monitoring Real Application Clusters Performance

Overview of Monitoring Real Application Clusters Databases

Configuration Recommendations for Optimal Performance

Using User-Mode IPC Protocols

Sizing the Buffer Cache and Shared Pool

Verifying the Interconnect Settings for Real Application Clusters

Performance Views in Real Application Clusters

Real Application Clusters Performance Statistics

The Content of Real Application Clusters Statistics

Recording Statistics

Using Statspack and Statistics to Monitor Real Application Clusters Performance

Using Statspack in Real Application Clusters

Monitoring Performance by Analyzing GCS and GES Statistics

Analyzing Wait Events

Using "CACHE_TRANSFER" Views to Analyze Real Application Clusters Statistics

5 Monitoring Performance in Real Application Clusters with Oracle Performance Manager

Oracle Performance Manager Overview

Using Performance Manager Charts for Previous Oracle Cluster Software Releases

Displaying the Oracle Performance Manager Charts for Real Application Clusters

Real Application Clusters-Specific Performance Manager Chart Hierarchies

Real Application Clusters-Specific Charts in Performance Manager

Total Transfer Chart

Global Cache CR Request Chart

Global Cache Convert Chart

Library Cache Lock Chart

Row Cache Lock Chart

Global Cache Current Block Request Chart

Real Application Clusters-Specific Versions of Oracle Charts

File I/O Rate Chart

Sessions Chart

Users Chart

Real Application Clusters Top Sessions Chart

Real Application Clusters Database Health Overview Chart

Part III Real Application Clusters Reference

A Configuring Multi-Block Lock Assignments (Optional)

Before You Override the Global Cache and Global Enqueue Service Resource Control Mechanisms

Deciding to Override Global Cache and Global Enqueue Service Processing

When to Use Locks

Setting GC_FILES_TO_LOCKS

GC_FILES_TO_LOCKS Syntax

Lock Assignment Examples

Additional Considerations for Setting GC_FILES_TO_LOCKS

Expanding or Adding Datafiles

Files To Avoid Including in GC_FILES_TO_LOCKS Settings

Tuning Parallel Execution on Real Application Clusters

Analyzing Real Application Clusters I/O Statistics

Analyzing Real Application Clusters I/O Statistics Using V$SYSSTAT

Monitoring Multi-Block Lock Usage by Detecting False Forced Writes

Lock Names and Lock Formats

Lock Names and Lock Name Formats

Lock Names

Lock Types and Names

B Using Free Lists and Free List Groups in Real Application Clusters (Optional)

Using Free List Groups For Concurrent Inserts from Multiple Nodes

The Purpose of Free Lists and Free List Groups

Deciding Whether to Create Database Objects with Free List Groups

Determining FREELIST GROUPS Reorganization Needs

Creating Tables, Clusters, and Indexes with FREELISTS and FREELIST GROUPS

Associating Instances and User Sessions with Free List Groups

Extent Management

Preallocating Extents

Extent Management and Locally Managed Tablespaces

Glossary

Index