Flylib.com
Optimizing Oracle Performance
Optimizing Oracle Performance
ISBN: 059600527X
EAN: 2147483647
Year: 2002
Pages: 102
Authors:
Cary Millsap
,
Jeff Holt
BUY ON AMAZON
Optimizing Oracle Performance
Table of Contents
Copyright
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
Section 1.1. You re Doing It Wrong
Section 1.2. Requirements of a Good Method
Section 1.3. Three Important Advances
Section 1.4. Tools for Analyzing Response Time
Section 1.5. Method R
Chapter 2. Targeting the Right User Actions
Section 2.1. Specification Reliability
Section 2.2. Making a Good Specification
Section 2.3. Specification Over-Constraint
Chapter 3. Targeting the Right Diagnostic Data
Section 3.1. Expectations About Data Collection
Section 3.2. Data Scope
Section 3.3. Oracle Diagnostic Data Sources
Section 3.4. For More Information
Chapter 4. Targeting the Right Improvement Activity
Section 4.1. A New Standard of Customer Care
Section 4.2. How to Find the Economically Optimal Performance Improvement Activity
Section 4.3. Making Sense of Your Diagnostic Data
Section 4.4. Forecasting Project Net Payoff
Part II: Reference
Chapter 5. Interpreting Extended SQL Trace Data
Section 5.1. Trace File Walk-Through
Section 5.2. Extended SQL Trace Data Reference
Section 5.3. Response Time Accounting
Section 5.4. Evolution of the Response Time Model
Section 5.5. Walking the Clock
Section 5.6. Forward Attribution
Section 5.7. Detailed Trace File Walk-Through
Section 5.8. Exercises
Chapter 6. Collecting Extended SQL Trace Data
Section 6.1. Understanding Your Application
Section 6.2. Activating Extended SQL Trace
Section 6.3. Finding Your Trace File(s)
Section 6.4. Eliminating Collection Error
Section 6.5. Exercises
Chapter 7. Oracle Kernel Timings
Section 7.1. Operating System Process Management
Section 7.2. Oracle Kernel Timings
Section 7.3. How Software Measures Itself
Section 7.4. Unaccounted-for Time
Section 7.5. Measurement Intrusion Effect
Section 7.6. CPU Consumption Double-Counting
Section 7.7. Quantization Error
Section 7.8. Time Spent Not Executing
Section 7.9. Un-Instrumented Oracle Kernel Code
Section 7.10. Exercises
Chapter 8. Oracle Fixed View Data
Section 8.1. Deficiencies of Fixed View Data
Section 8.2. Fixed View Reference
Section 8.3. Useful Fixed View Queries
Section 8.4. The Oracle Wait Interface
Section 8.5. Exercises
Chapter 9. Queueing Theory for the Oracle Practitioner
Section 9.1. Performance Models
Section 9.2. Queueing
Section 9.3. Queueing Theory
Section 9.4. The MMm Queueing Model
Section 9.5. Perspective
Section 9.6. Exercises
Part III: Deployment
Chapter 10. Working the Resource Profile
Section 10.1. How to Work a Resource Profile
Section 10.2. How to Forecast Improvement
Section 10.3. How to Tell When Your Work Is Done
Chapter 11. Responding to the Diagnosis
Section 11.1. Beyond the Resource Profile
Section 11.2. Response Time Components
Section 11.3. Eliminating Wasteful Work
Section 11.4. Attributes of a Scalable Application
Chapter 12. Case Studies
Section 12.1. Case 1: Misled by System-Wide Data
Section 12.2. Case 2: Large CPU Service Duration
Section 12.3. Case 3: Large SQLNet Event Duration
Section 12.4. Case 4: Large Read Event Duration
Section 12.5. Conclusion
Part IV: Appendixes
Glossary
Appendix A. Greek Alphabet
Appendix B. Optimizing Your Database Buffer Cache Hit Ratio
Appendix C. MMm Queueing Theory Formulas
Appendix D. References
Colophon
Optimizing Oracle Performance
ISBN: 059600527X
EAN: 2147483647
Year: 2002
Pages: 102
Authors:
Cary Millsap
,
Jeff Holt
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
Answers to Assessment Test
Cost Planning
Project Execution
Project Closure
Appendix B Standard IT Project Documents
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Distributed Data Warehouse for Geo-spatial Services
Healthcare Information: From Administrative to Practice Databases
A Hybrid Clustering Technique to Improve Patient Data Quality
Systematic Software Testing (Artech House Computer Library)
Detailed Test Planning
The Test Organization
Some Final Thoughts…
Appendix C IEEE Templates
Appendix D Sample Master Test Plan
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Removing Weird Characters from Imported Text
Annotating Charts
Applying Discrete Fourier Transforms
Tackling Nonlinear Systems of Equations
Introduction
Cisco IOS Cookbook (Cookbooks (OReilly))
Changing Privilege Level of IOS Commands
Converting Ethernet and Token Ring MAC Addresses
Logging Router Syslog Messages in Different Files
Limiting the Impact of IP Helper Addresses
Defining DHCP Lease Periods
Sap Bw: a Step By Step Guide for Bw 2.0
Organizing Workbooks Using BEx Browser
Integrating Profile Generator and BEx Browser
InfoCube Design Alternative II-Dimension Characteristics
Multi-Cubes
Section B.2. Dispatcher, Work Processes, and Services
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies