Optimizing Oracle performance / Cary Millsap ; with Jeff Holt.
- First edition.
- Sebastopol, California : O'Reilly, 2003.
1 online resource (418 p.)
- Oracle (Computer file).
- Electronic books.
- System Details:
- text file
- Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient. Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and
- Table of Contents; 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; A Better Way to Optimize; "You're Doing It Wrong"; Requirements of a Good Method; Three Important Advances; User Action Focus; Response Time Focus; Amdahl's Law; All Together Now; Tools for Analyzing Response Time; Sequence Diagram; Resource Profile; MethodR; Who Uses the Method
The abominable smokestackThe optimal performance analyst; Your role; Overcoming Common Objections; "But my whole system is slow"; "The method only works if the problem is the database"; "The method is unconventional"; Evaluation of Effectiveness; Targeting the Right User Actions; Specification Reliability; The System; Economic Constraints; Making a Good Specification; User Action; Identifying the Right User Actions and Contexts; Prioritizing the User Actions; Determining Who Will Execute Each Action and When; Specification Over-Constraint; Targeting the Right Diagnostic Data
Expectations About Data CollectionData Scope; Scoping Errors; Long-Running User Actions; "Too Much Data" Is Really Not Enough Data; Oracle Diagnostic Data Sources; For More Information; Targeting the Right ImprovementActivity; 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; Forecasting Project Benefits; Monetizing the benefits; If you can't monetize the benefits; Forecasting Project Cost; Forecasting Project Risk; Part II; Interpreting Extended SQL Trace Data
Trace File Walk-ThroughExtended SQL Trace Data Reference; Trace File Element Definitions; Cursor numbers; Session identification and timestamps; Application identification; Cursor identification; Database calls; Wait events; Bind variables; Row source operations; Transaction end markers; Reference summary; Oracle Time Units; Response Time Accounting; Time Within a Database Call; Time Between Database Calls; Recursive SQL Double-Counting; Parent-child relationships; Recursive statistics; Evolution of the Response Time Model; Walking the Clock; Oracle Release 8 and Prior; Oracle Release 9
Clock Walk FormulasForward Attribution; Forward Attribution for Within-Call Events; Forward Attribution for Between-Call Events; Detailed Trace File Walk-Through; Exercises; Collecting Extended SQL Trace Data; Understanding Your Application; Activating Extended SQL Trace; Tracing Your Own Source Code; Tracing Someone Else's Source Code; Triggering a session to activate its own trace; Activating trace from a third-party session; Finding Your Trace File(s); Trace File Names; Simple Client-Server Applications; Oracle Parallel Execution; Oracle Multi-Threaded Server
- Includes bibliographical references (p. 374-380) and index.
Description based on print version record.
- Holt, Jeff.
|Location||Notes||Your Loan Policy|
|Description||Status||Barcode||Your Loan Policy|