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.

• Written for developers by an application developer who has learned by doing

• Gives a systematic approach to solving database application performance problems

• Helps you plan for performance as you would for any other application requirement

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 6 Ratings

A MUST for Developers and DBAs - 2008-09-30
Reviewer Rating:
BOTH Developers and DBAs can learn from this book. Along the line of "Optimizing Oracle Performance" by Cary Milsap; this books shows by clear examples how to Identify Performance Problems (Chapter 3) and how to solve those problems (the remainder of the book).

Developers can learn how to Instrument code to help the tuning process.
DBAs can then trace the code and find the bottleneck/waits.

This book bridges the gap between Developers and DBAs and points out indirectly that Performance is a teams effort and solution.

Excellent work - 2008-12-10
Reviewer Rating:
This book is exremely useful for Oracle Administrators and Developers alike. It is easy to understand and contains valuable information for everybody interested in understanding Oracle performance issues. The author demonstrates an excellent method to identify wrong Optimizer estimates that lead to suboptimal execution plans.

The author shares dozens of "best-practices" and advices from his personal consulting experience as well es detailed information which is not available in Oracle documentation.

My personal highlight was the introduction to a sophisticated, yet easy-to-use SQL Trace Analyzer TVD$XTAT which overcomes the limits of tkprof for SQL Response Time Analysis.

This book is a must-have for every Oracle professional.

Martin Decker
ora-solutions.net

Nothing new. Save your Money ... - 2009-06-23
Reviewer Rating:
With all the 5 star reviews, I was excited to get my copy and was disappointed with the contents.

So far I have finished 6 chapters - I did not find any new techniques. The same old tkprof, explain plan and query optimizer. I will update the review when I complete the rest of the book.

Excellent book on Oracle Performance Troubleshooting - 2009-10-03
Reviewer Rating:
This is an excellent book on Oracle Performance Trouble Shooting.The book is well presented.Provides lot of insights on Joins ,Partioning and Parallel Processing.Any
tuning specialist most likely would refer this book again and again.

Great book on Oracle 11g Troubleshooting - 2009-03-30
Reviewer Rating:
The author Christian Antognini has done a wonderful job in writing a great book on how to systematically analyze issues with Oracle 11g. Let's be honest, Oracle 11g is a beast and take a very long time to master all areas of its core functionality. I have been using Oracle for only a few years and I sometime still consider myself a newbie.

The recent version of 11g has added lots of new functionality such as database replay, sql access advisor, sucurefiles, flashback data archiving, tablespace encryption, data masking and so much more. IT sometimes feels that version 11g is a totally new database compared to version 10.x.

The great thing about this book which others fail is that it covers all versions of Oracle from version 9i to 11gR1. So even if you are using an older version this book still is extremely valuable to own. It will actually save you money if you are using an older version of Oracle because it can be used as you gradually upgrade to newer versions of Oracle. Another reason to buy it!

This book assumes that you already have a good knowledge of using Oracle and goes right into many different scenarios of using different front-end technologies where performance issues can happen and hot to step-by-step figure out where your problem may be coming from.

The author focuses on tracing database calls, profiling PL/SQL code, how to review workload statistics and object statistics, how to configure your query optimizer, and one of the most useful sections of the book is Chapter 6 where the author focus on many different execution plans. I also liked Chapter 10 where the author goes through all the different types of SQL commands (joins, nested loops, merge joins, hash joins, etc.) and how they can be improved and optimized.

For the size of the book (500+), the author really gives you some great material that can be used for many years of using Oracle. It can be used for the beginner Oracle user (after they get their feet wet) for understanding how to write SQL the optimized way, for the Application Oracle developer and for the DBA as well.

I cant see how this book cannot be in your library. A must buy!

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > Oracle
Oracle > Troubleshooting/Performance Tuning
Databases > Performance Tuning