Troubleshooting Oracle Performance / Edition 1by Christian Antognini
Pub. Date: 06/03/2008
When your database application isn’t running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application
When your database application isn’t running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more 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, this book shows you how to plan for performance as you would for any other application requirement.
- Publication date:
- Edition description:
- Product dimensions:
- 6.80(w) x 9.30(h) x 1.50(d)
Table of Contents
Most Helpful Customer Reviews
See all customer reviews
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!