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
Similar book on Amazon
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Oracle Core: Essential Internals for DBAs and Developers
Troubleshooting Oracle Performance
Cost-Based Oracle Fundamentals (Expert's Voice in Oracle)
Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
The CISSP and CAP Prep Guide: Platinum Edition
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Cisco IPC Express System Components
Summary
Digit Manipulation
Summary
Table vm_bcst_heard
Adobe After Effects 7.0 Studio Techniques
Blue-Screen and Green-Screen Keying
Camera Blur
Film and Video Looks
Floating Point
Sky Replacement
Cisco CallManager Fundamentals (2nd Edition)
Summary
H.323 Gateways
Overview of CDR Data
Cisco CallManager Feature List
QSIG
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
RIP
Domain Name System
NetBIOS
System Maintenance
Case Study 2: Large Enterprise Firewall, VPN, and IPS Deployment
.NET-A Complete Development Cycle
The .NET Framework
The C# Language
Initial Requirements Analysis and Design
Unit Tests
Design of the Image-Processing Components Using Late Binding
Comparing, Designing, and Deploying VPNs
Configuring and Verifying L2TPv3 Pseudowires
Designing MPLS Layer 3 Site-to-Site VPNs
Advantages and Disadvantages of IPsec Site-to-Site VPNs
Designing QoS for IPsec VPNs
Review Questions
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