Dedication;Foreword;Preface; Why I Wrote This Book; Audience for This Book; Structure of This Book; Which Platform and Version?; What This Book Is and Is Not; About the Tools, Examples, and Exercises; Citations; Conventions Used in This Book; Comments and Questions; Acknowledgments;Part I: Method; Chapter 1: A Better Way to Optimize; 1.1 "You're Doing It Wrong"; 1.2 Requirements of a Good Method; 1.3 Three Important Advances; 1.4 Tools for Analyzing Response Time; 1.5 Method R; Chapter 2: Targeting the Right User Actions; 2.1 Specification Reliability; 2.2 Making a Good Specification; 2.

3 Specification Over-Constraint; Chapter 3: Targeting the Right Diagnostic Data; 3.1 Expectations About Data Collection; 3.2 Data Scope; 3.3 Oracle Diagnostic Data Sources; 3.4 For More Information; Chapter 4: Targeting the Right Improvement Activity; 4.1 A New Standard of Customer Care; 4.2 How to Find the Economically Optimal Performance Improvement Activity; 4.3 Making Sense of Your Diagnostic Data; 4.

4 Forecasting Project Net Payoff;Part II: Reference; Chapter 5: Interpreting Extended SQL Trace Data; 5.1 Trace File Walk-Through; 5.2 Extended SQL Trace Data Reference; 5.3 Response Time Accounting; 5.4 Evolution of the Response Time Model; 5.5 Walking the Clock; 5.6 Forward Attribution; 5.7 Detailed Trace File Walk-Through; 5.

8 Exercises; Chapter 6: Collecting Extended SQL Trace Data; 6.1 Understanding Your Application; 6.2 Activating Extended SQL Trace; 6.3 Finding Your Trace File(s); 6.4 Eliminating Collection Error; 6.5 Exercises; Chapter 7: Oracle Kernel Timings; 7.1 Operating System Process Management; 7.2 Oracle Kernel Timings; 7.

3 How Software Measures Itself; 7.4 Unaccounted-for Time; 7.5 Measurement Intrusion Effect; 7.6 CPU Consumption Double-Counting; 7.7 Quantization Error; 7.8 Time Spent Not Executing; 7.9 Un-Instrumented Oracle Kernel Code; 7.10 Exercises; Chapter 8: Oracle Fixed View Data; 8.

1 Deficiencies of Fixed View Data; 8.2 Fixed View Reference; 8.3 Useful Fixed View Queries; 8.4 The Oracle "Wait Interface"; 8.5 Exercises; Chapter 9: Queueing Theory for the Oracle Practitioner; 9.1 Performance Models; 9.2 Queueing; 9.3 Queueing Theory; 9.

4 The M/M/m Queueing Model; 9.5 Perspective; 9.6 Exercises;Part III: Deployment; Chapter 10: Working the Resource Profile; 10.1 How to Work a Resource Profile; 10.2 How to Forecast Improvement; 10.3 How to Tell When Your Work Is Done; Chapter 11: Responding to the Diagnosis; 11.1 Beyond the Resource Profile; 11.2 Response Time Components; 11.

3 Eliminating Wasteful Work; 11.4 Attributes of a Scalable Application; Chapter 12: Case Studies; 12.1 Case 1: Misled by System-Wide Data; 12.2 Case 2: Large CPU Service Duration; 12.3 Case 3: Large SQL*Net Event Duration; 12.4 Case 4: Large Read Event Duration; 12.5 Conclusion;Part IV: Appendixes; Appendix A: Greek Alphabet; Appendix B: Optimizing Your Database Buffer Cache Hit Ratio; Appendix C: M/M/m Queueing Theory Formulas; Appendix D: References;Colophon;.