Based on author Christopher Lawson's long experience working with Oracle, this practical guide 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.
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshootingno more, no less.
Expert Oracle SQL: Optimization, Deployment, and Statistics shows how to optimize individual SQL statements by diagnosing a problem, identifying a fix, and implementing that fix safely on a production system.
In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewisone of the foremost authorities in this fielddescribes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong.