Overview

Full Product Details

Author:   Cary Millsap ,  Jeff Holt
Publisher:   O'Reilly Media
Imprint:   O'Reilly Media
Dimensions:   Width: 17.20cm , Height: 2.50cm , Length: 23.40cm
Weight:   0.642kg
ISBN:  

9780596005276

ISBN 10:   059600527
Pages:   390
Publication Date:   21 October 2003
Audience:   College/higher education ,  Professional and scholarly ,  Undergraduate ,  Postgraduate, Research & Scholarly
Format:   Paperback
Publisher's Status:   Active
Availability:   In Print  
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.

Table of Contents

"Part I. Method 1. A Better Way to Optimize ""You're Doing It Wrong"" Requirements of a Good Method Three Impor tant 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 Res ponse 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. Deployment10. 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."

Reviews

Author Information

Cary Millsap is the former Vice President of Oracle's System Performance Group and the cofounder of Hotsos (http://www.hotsos.com), a company dedicated to Oracle system performance. Hotsos provides performance-improvement tools for Oracle environments and also delivers training in the form of clinics and symposiums. Cary is also a founding member of the Oak Table Network (http://www.oaktable.net), an informal association of ""Oracle Scientists"" well known throughout the Oracle community. Jeff Holt is one of the world's most productive Oracle performance optimization specialists. He has tremendous experience in constructing training programs and software tools to optimize the system performance management process. He is a former support analyst and consultant at Oracle Corporation, where he served as a technology leader in the System Performance Group. He is the Hotsos Tools lead designer and developer, the author of several technical papers, a Hotsos founding employee, and a Hotsos Clinic principal developer.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions