Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
Troubleshooting Oracle Performance (Expert's Voice in Oracle) 2008th Edition
Use the Amazon App to scan ISBNs and compare prices.
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
Customers Who Viewed This Item Also Viewed
Top Customer Reviews
What this book accomplishes, which most other performance tuning books seem to miss, is to indicate which performance tuning features are available in each Oracle release (and which are available at no additional licensing cost) as the various performance tuning approaches are discussed. Not only does the book indicate when a feature would be appropriate, but also potential problems ("Pitfalls and Fallacies") associated with each feature.
The depth of coverage of Oracle 11g R1 features is surprisingly thorough given the short amount of time which that version has been on the market. A little more detail in a couple areas, such as hacking stored outlines, would have been helpful; at the same time, everyone who reads the book might have a different opinion of what needed additional detail, the book could have grown to 2500 or more pages, and likely would have been obsolete by the time it was published.
The Apress Roadmap on the back cover of the book indicates that this book should be read before "Forecasting Oracle Performance", "Expert Oracle Database Architecture", and "Cost-Based Oracle Fundamentals". The "Troubleshooting Oracle Performance" book seems to assume that the Oracle database concepts are well understood.Read more ›
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.
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.Read more ›
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.
Most Recent Customer Reviews
This is an excellent and very helpful book which employs a systematic approach and interesting wrtiting style to keep the reader interested. Read morePublished on December 19, 2010 by Mladen Gogala
I searched for this book "Troubleshooting Oracle Performance" in a native language, but searches haven't gone right and it was necessary to buy it in the original. Read morePublished on August 24, 2010 by zerohalf
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. Read morePublished on October 3, 2009 by David Raj Daniel