Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters or following a set prescriptionit involves matching application-specific knowledge with what's happening inside the database.
Based on author Christopher Lawson's long experience working with Oracle, The Art and Science of Oracle Performance Tuning book uses a five-step model to help identify and isolate the cause of nonperformance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success.
| Introduction | 1 | |
| Ch. 1 | The Challenge of Performance Tuning | 5 |
| Ch. 2 | Why Many Tuning Strategies Fail | 25 |
| Ch. 3 | The Oracle Physician | 53 |
| Ch. 4 | Dealing with Humans | 73 |
| Ch. 5 | The Oracle Detective | 95 |
| Ch. 6 | Gathering More Clues | 129 |
| Ch. 7 | The Oracle Pathologist | 159 |
| Ch. 8 | Analyzing SQL Bottlenecks | 189 |
| Ch. 9 | Analyzing SQL Joins | 227 |
| Ch. 10 | The Pathologist's Toolkit: Other Tactics | 269 |
| Ch. 11 | The Oracle Artist | 317 |
| Ch. 12 | The Artist's Palette: More on Devising Solutions | 357 |
| Ch. 13 | The Oracle Magician | 387 |
| Ch. 14 | Case Studies | 409 |
| App. A | Useful V$ View Definitions | 429 |
| Index | 439 |
Anonymous
Posted Wed Apr 02 00:00:00 EST 2003
This book is extremely helpful for most database problems. Highly recommended.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Sat Apr 05 00:00:00 EST 2003
The Art and Science of Oracle performance tuning is a surprisingly unique Oracle book. Rather than focusing on technical scripts and remedies, Chris Lawson takes the approach of the Oracle detective, packing this book with insights and techniques in order to diagnose the root causes of Oracle performance problems. Throughout the text, Lawson shares investigative techniques that are extremely helpful in locating the root causes of all sorts of performance tuning problems. Especially useful are Lawson's sections on SQL tuning and PGA memory management. Overall, this is a surprisingly comprehensive book that focuses on the approach to be taken by the Oracle tuning expert to quickly and efficiently identifying the causes of Oracle performance problems.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications. Consequently, it is highly tunable, presenting a bewildering set of choices to the inexperienced. Tuning Oracle is as much about approach as about understanding the technology. It is more than tweaking parameters or following a set prescriptionit involves matching application-specific ...