1. Method

   1. Chapter 1 A Better Way to Optimize

      1. "You're Doing It Wrong"
      2. Requirements of a Good Method
      3. Three Important Advances
      4. Tools for Analyzing Response Time
      5. Method R

   2. Chapter 2 Targeting the Right User Actions

      1. Specification Reliability
      2. Making a Good Specification
      3. Specification Over-Constraint

   3. Chapter 3 Targeting the Right Diagnostic Data

      1. Expectations About Data Collection
      2. Data Scope
      3. Oracle Diagnostic Data Sources
      4. For More Information

   4. Chapter 4 Targeting the Right Improvement Activity

      1. A New Standard of Customer Care
      2. How to Find the Economically Optimal Performance Improvement Activity
      3. Making Sense of Your Diagnostic Data
      4. Forecasting Project Net Payoff

2. Reference

   1. Chapter 5 Interpreting Extended SQL Trace Data

      1. Trace File Walk-Through
      2. Extended SQL Trace Data Reference
      3. Response Time Accounting
      4. Evolution of the Response Time Model
      5. Walking the Clock
      6. Forward Attribution
      7. Detailed Trace File Walk-Through
      8. Exercises

   2. Chapter 6 Collecting Extended SQL Trace Data

      1. Understanding Your Application
      2. Activating Extended SQL Trace
      3. Finding Your Trace File(s)
      4. Eliminating Collection Error
      5. Exercises

   3. Chapter 7 Oracle Kernel Timings

      1. Operating System Process Management
      2. Oracle Kernel Timings
      3. How Software Measures Itself
      4. Unaccounted-for Time
      5. Measurement Intrusion Effect
      6. CPU Consumption Double-Counting
      7. Quantization Error
      8. Time Spent Not Executing
      9. Un-Instrumented Oracle Kernel Code
      10. Exercises

   4. Chapter 8 Oracle Fixed View Data

      1. Deficiencies of Fixed View Data
      2. Fixed View Reference
      3. Useful Fixed View Queries
      4. The Oracle "Wait Interface"
      5. Exercises

   5. Chapter 9 Queueing Theory for the Oracle Practitioner

      1. Performance Models
      2. Queueing
      3. Queueing Theory
      4. The M/M/m Queueing Model
      5. Perspective
      6. Exercises

3. Deployment

   1. Chapter 10 Working the Resource Profile

      1. How to Work a Resource Profile
      2. How to Forecast Improvement
      3. How to Tell When Your Work Is Done

   2. Chapter 11 Responding to the Diagnosis

      1. Beyond the Resource Profile
      2. Response Time Components
      3. Eliminating Wasteful Work
      4. Attributes of a Scalable Application

   3. Chapter 12 Case Studies

      1. Case 1: Misled by System-Wide Data
      2. Case 2: Large CPU Service Duration
      3. Case 3: Large SQL*Net Event Duration
      4. Case 4: Large Read Event Duration
      5. Conclusion

4. Appendixes

   1. Appendix A Greek Alphabet

   2. Appendix B Optimizing Your Database Buffer Cache Hit Ratio

   3. Appendix C M/M/m Queueing Theory Formulas

   4. Appendix D References

1. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animals on the cover of Optimizing Oracle Performance are yellowjackets. Though frequently mistaken for bees, yellowjackets are a type of wasp. They can be distinguished from bees by their lack of hair. They also often have brighter black and yellow coloring on their tails. Yellowjackets are around half an inch long, and the queen is about three-quarters of an inch long. They can be found throughout North America. Wasps build nests by chewing bits of wood and leaves into a paper-like pulp. The nest is built in a dry, protected place such as a tree, log, shrub, or hole in the ground, or attached to a building.

Yellowjackets live in large colonies comprising a queen, female workers, and males. In the spring, the queen, who is the only yellowjacket that breeds, builds a small nest and lays eggs. When they hatch, the female workers expand the nest, look for food, and take care of the queen and the colony. The males fertilize the queen, who continues to lay eggs and expand the colony. In the winter, all yellowjackets except the queen die.

Yellowjackets are scavengers. They eat other insects, rotting fruit, and garbage. They are often considered to be pests because they are attracted to the food at picnics. Yellowjackets can sting repeatedly. Humans should avoid yellowjackets, which are attracted to bright clothing and sweet smells. If you encounter a yellowjacket, stay calm and walk away slowly. Swatting at it may anger it and cause it to sting. Furthermore, if hit, a yellowjacket may release venom into the air, which is an alarm signal that will summon other yellowjackets. Yellowjackets are beneficial because they eat large numbers of agricultural pests. Jane Ellin was the production editor and proofreader for Optimizing Oracle Performance. Emily Quill provided quality control. James Quill and Jamie Peppard provided production support. Nancy Crumpton wrote the index.

Ellie Volckhausen designed the cover of this book, based on a series design by Edie Freedman. The cover image is a 19th-century engraving from the Dover Pictorial Archive. Emma Colby produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font.

David Futato designed the interior layout. This book was converted by Joe Wizda to FrameMaker 5.5.6 with a format conversion tool created by Erik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was written by Jane Ellin.