Antognini C. Troubleshooting Oracle performance

Chicago: Appress, friendsof, 2014. — 698 p.Oracle Database has become a huge piece of software. This not only means that a single human can no longer be proficient in using all the features provided recent versions, it also means that some features will rarely be used. Actually, in most situations, it's enough to know and take advantage of a limited number of core features in order to use Oracle Database efficiently and successfully. This is precisely why this book covers only the features that, based on my experience, are necessary to troubleshoot most of the database-related performance problems you will encounter.Foreword by Jonathan Lewis
Foreword by Cary Millsap
Foreword from the First Edition
About the Autor
About Technival ReviewersAcknowledgments from the First EditionFoundations
Perfomance problems
Key ConceptsIdentification
Analysis of Reproducible Problems
Real-Time Analysis of Irreproducible Problems
Postmortem Analysis of Irreproducible ProblemsQuery Optimizer
Introducing the Query Optimizer
System Statistics
Object Statistics
Configuring the Query Optimizer
Execution PlansOptimization
SQL Optimization Techniques
Parsing
Optimizing Data Access
Optimizing Joins
Beyond Data Access and Join Optimization
Optimizing the Physical DesignAppendix