Troubleshooting Oracle Performance

Book: 

Troubleshooting Oracle Performance, Hardback

Author: Christian Antognini

Publisher: APRESS ACADEMIC (2008)

Binding: Hardcover, 584 pages

What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
 
This book shows you how to do the following:

• Identify performance problems using a systematic and repeatable approach.
• Configure the query optimizer to meet your application performance goals.
• Obtain and interpret execution plans as well as assess whether they are inefficient.
• Apply SQL tuning techniques such as hints, SQL profiles, stored outlines and SQL plan baselines.
• Minimize the impact of parsing without jeopardizing performance.
• Optimize data access, joins and the physical design.
• Improve performance through parallel processing, materialized views, and result caching.

This book is intended for performance analysts, application developers and database administrators who are involved in troubleshooting performance problems of applications based on the Oracle database engine.
No specific knowledge in optimization is required. However, readers are expected to have a working knowledge of the Oracle database engine and to be proficient with SQL.