Contents Listing

Foreword



Preface





Part I. Method



1. A Better Way to Optimize

"You're Doing It Wrong"

Requirements of a Good Method

Three Important Advances

Tools for Analyzing Response Time

Method R



2. Targeting the Right User Actions

Specification Reliability

Making a Good Specification

Specification Over-Constraint



3. Targeting the Right Diagnostic Data

Expectations About Data Collection

Data Scope

Oracle Diagnostic Data Sources

For More Information



4. Targeting the Right Improvement Activity

A New Standard of Customer Care

How to Find the Economically Optimal Performance Improvement Activity

Making Sense of Your Diagnostic Data

Forecasting Project Net Payoff





Part II. Reference



5. Interpreting Extended SQL Trace Data

Trace File Walk-Through

Extended SQL Trace Data Reference

Response Time Accounting

Evolution of the Response Time Model

Walking the Clock

Forward Attribution

Detailed Trace File Walk-Through

Exercises



6. Collecting Extended SQL Trace Data

Understanding Your Application

Activating Extended SQL Trace

Finding Your Trace File(s)

Eliminating Collection Error

Exercises



7. Oracle Kernel Timings

Operating System Process Management

Oracle Kernel Timings

How Software Measures Itself

Unaccounted-for Time

Measurement Intrusion Effect

CPU Consumption Double-Counting

Quantization Error

Time Spent Not Executing

Un-Instrumented Oracle Kernel Code

Exercises



8. Oracle Fixed View Data

Deficiencies of Fixed View Data

Fixed View Reference

Useful Fixed View Queries

The Oracle "Wait Interface"

Exercises



9. Queueing Theory for the Oracle Practitioner

Performance Models

Queueing

Queueing Theory

The M/M/m Queueing Model

Perspective

Exercises





Part III. Deployment

10. Working the Resource Profile

How to Work a Resource Profile

How to Forecast Improvement

How to Tell When Your Work Is Done



11. Responding to the Diagnosis

Beyond the Resource Profile

Response Time Components

Eliminating Wasteful Work

Attributes of a Scalable Application



12. Case Studies

Case 1: Misled by System-Wide Data

Case 2: Large CPU Service Duration

Case 3: Large SQL*Net Event Duration

Case 4: Large Read Event Duration

Conclusion





Part IV. Appendixes



A. Glossary



B. Greek Alphabet



C. Optimizing Your Database Buffer Cache Hit Ratio



D. M/M/m Queueing Theory Formulas



E. References





Index