Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts

An indispensable guide for any Oracle professional looking for tuning techniques, this reference for database administrators features techniques for monitoring and optimizing memory storage. Focusing on specific troubleshooting methods such as pinpointing and fixing troublesome SQL, this updated second edition includes new material on Oracle 10g and 11g, explains ratio-based and bottleneck trouble shooting analysis, and uses the Oracle data dictionary for in-depth assessments of both simple and complex Oracle performance problems.