Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Designing and Developing for Performance

Oracle's New Methodology

Understanding Investment Options

Understanding Scalability

What is Scalability?

Internet Scalability

Factors Preventing Scalability

System Architecture

Hardware and Software Components

Configuring the Right System Architecture for Your Requirements

Application Design Principles

Simplicity In Application Design

Data Modeling

Table and Index Design

Using Views

SQL Execution Efficiency

Implementing the Application

Trends in Application Development

Workload Testing, Modeling, and Implementation

Sizing Data

Estimating Workloads

Application Modeling

Testing, Debugging, and Validating a Design

Deploying New Applications

Rollout Strategies

Performance Checklist

2 Monitoring and Improving Application Performance

Importance of Statistics

Statistics Gathering Tools

Importance of Historical Data and Baselines

Performance Intuition

The Oracle Performance Improvement Method

Introduction to Performance Improvement

Steps in The Oracle Performance Improvement Method

How to Check the Operating System

A Sample Decision Process for Performance Conceptual Modeling

Top Ten Mistakes Found in Oracle Systems

Performance Characteristics of Hardware Configurations

3 Emergency Performance Techniques

Introduction to Emergency Performance Techniques

Steps in the Emergency Performance Method

Index