Oracle Performance Survival Guide (PDF)

Oracle Performance Survival Guide offers a structured methodology for optimizing Oracle performance in the most systematic and efficient manner possible. Authored by leading Oracle expert Guy Harrison, this is the first book to contain up-to-the-minute guidance for optimizing the performance of the new Oracle 11g Release 2. Harrison helps DBAs and developers quickly and efficiently optimize performance by focusing on causes rather than symptoms, and by identifying the areas that will deliver the greatest "bang for the buck" in their applications and environments. He covers every area of Oracle performance management, from application design through SQL tuning, content management through memory and physical IO management. Harrison begins by introducing Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. He illuminates the interaction between applications and databases, guides Oracle professionals through choosing tuning tools, and covers a wide range of techniques for efficient application design. Coverage includes statistics collection, configuration objects, and tuning table accesses, joins, subqueries, sorts, and aggregates; eliminating contention; and much more.

• Shows how to tune performance efficiently, by addressing causes rather than symptoms
• Addresses all facets of performance, including application design, SQL tuning, content management, memory, physical IO, and more
• Helps tuners focus on the areas where the greatest gains can be found
• By Guy Harrison, author of the top-selling Oracle SQL High Performance Tuning