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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to SQL Server Using Integrated Security from ASP.NET
Filtering and Sorting Data
Transferring Login Credentials Securely
Improving DataReader Performance with Typed Accessors
A.5. Class, Structure, and Interface Members
The .NET Developers Guide to Directory Services Programming
System.DirectoryServices.ActiveDirectory Overview
Binary Data Conversion
Writing COM Interop Types
Directory Object Permissions in Active Directory and ADAM
Summary
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 6 Basic Networking
Domain 4 Networks
Adobe After Effects 7.0 Studio Techniques
Alpha Channels and Premultiplication
Optimizing After Effects
Beyond the Basics
Conclusion
Looping Animations
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
Competency-Based Employee Recruitment and Selection
Competency-Based Employee Development
Competency-Based HR Management The Next Steps
Appendix D Employee Development and Succession Management
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 4. Connect Linux with a Bluetooth Phone
Hacks 4051: Introduction
Hack 95. Build a Wireless Network for the Large House
Hack 97. Calculate the Link Budget
Hack 98. Align Antennas at Long Distances
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