Troubleshooting Oracle Performance

This book provides a systematic approach to addressing the underlying causes of poor database application performance. It shows readers how to plan for performance as they would for any other application requirement.

Here is a fantastic addition to Apress's ever-growing line of performance optimization titles for Oracle developers and database administrators written by internationally acclaimed experts. This book forges a strong link in the chain from performance problem to performance solution by giving readers a systematic method for solving problems once they've been identified. Christian Antognini's emphasis on planning for performance as an application requirement represents clear and fresh thinking on the problem of database performance. His use of roadmaps to provide a repeatable path from an identified problem to a solution makes his book genuinely helpful to readers who want more than a random collection of performance tips. Readers of Jonathan Lewis, Tom Kyte, Craig Shallahamer will welcome the chance to add Christian Antognini to their shelves.

Fills an open niche by providing repeatable processes in the form of roadmaps for addressing common problem areas Those roadmaps lead readers to solutions Author is respected member of the OakTable Network, which is an international organization of top, Oracle performance analysts Covers all currently in use versions of Oracle, from Oracle9i Database up through Oracle Database 11g

Autorentext
Since 1995, Christian Antognini has been focusing on understanding how the Oracle database engine works. His main interests range from logical and physical database design, to the integration of databases with Java applications, the query optimizer, and basically everything else related to performance management and tuning. He is working as a senior consultant and trainer at Trivadis AG in Z rich, Switzerland. If he is not helping one of his customers to get the most out of Oracle, he is somewhere lecturing on optimization or new Oracle database features for developers. He is member of the Trivadis Performance Team and of the OakTable Network).

Inhalt
Foundations.- Performance Problems.- Key Concepts.- Identification.- Identifying Performance Problems.- Query Optimizer.- System and Object Statistics.- Configuring the Query Optimizer.- Execution Plans.- SQL Tuning Techniques.- Optimization.- Parsing.- Optimizing Data Access.- Optimizing Joins.- Beyond Data Access and Join Optimization.- Optimizing the Physical Design.