| |
| |
| Foreword | |
| |
| |
| Preface | |
| |
| |
| |
| Method | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Targeting the Right User Actions | |
| |
| |
| Specification Reliability | |
| |
| |
| Making a Good Specification | |
| |
| |
| Specification Over-Constraint | |
| |
| |
| |
| Targeting the Right Diagnostic Data | |
| |
| |
| Expectations About Data Collection | |
| |
| |
| Data Scope | |
| |
| |
| Oracle Diagnostic Data Sources | |
| |
| |
| For More Information | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Reference | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Collecting Extended SQL Trace Data | |
| |
| |
| Understanding Your Application | |
| |
| |
| Activating Extended SQL Trace | |
| |
| |
| Finding Your Trace File(s) | |
| |
| |
| Eliminating Collection Error | |
| |
| |
| Exercises | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Oracle Fixed View Data | |
| |
| |
| Deficiencies of Fixed View Data | |
| |
| |
| Fixed View Reference | |
| |
| |
| Useful Fixed View Queries | |
| |
| |
| The Oracle "Wait Interface" | |
| |
| |
| Exercises | |
| |
| |
| |
| Queueing Theory for the Oracle Practitioner | |
| |
| |
| Performance Models | |
| |
| |
| Queueing | |
| |
| |
| Queueing Theory | |
| |
| |
| The M/M/m Queueing Model | |
| |
| |
| Perspective | |
| |
| |
| Exercises | |
| |
| |
| |
| Deployment | |
| |
| |
| |
| Working the Resource Profile | |
| |
| |
| How to Work a Resource Profile | |
| |
| |
| How to Forecast Improvement | |
| |
| |
| How to Tell When Your Work Is Done | |
| |
| |
| |
| Responding to the Diagnosis | |
| |
| |
| Beyond the Resource Profile | |
| |
| |
| Response Time Components | |
| |
| |
| Eliminating Wasteful Work | |
| |
| |
| Attributes of a Scalable Application | |
| |
| |
| |
| Case Studies | |
| |
| |
| |
| Misled by System-Wide Data | |
| |
| |
| |
| Large CPU Service Duration | |
| |
| |
| |
| Large SQL *Net Event Duration | |
| |
| |
| |
| Large Read Event Duration | |
| |
| |
| Conclusion | |
| |
| |
| |
| Appendixes | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Greek Alphabet | |
| |
| |
| |
| Optimizing Your Database Buffer Cache Hit Ratio | |
| |
| |
| |
| M/M/m Queueing Theory Formulas | |
| |
| |
| |
| References | |
| |
| |
| Index | |