Optimizing Oracle Performance
Optimizing Oracle Performance By Cary Millsap
With Jeff Holt
September 2003
Pages: 416

| Table of Contents | Index | Sample Chapter | Colophon

Table of Contents

  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

Return to Optimizing Oracle Performance