Troubleshooting Oracle Performance (Expert’s Voice in Oracle) [Christian Antognini] on *FREE* shipping on qualifying offers. When your database. Troubleshooting Oracle Performance [Christian Antognini] on * FREE* shipping on qualifying offers. Now available in paperback― What do you do. by Christian Antognini. Troubleshooting Oracle Performance, 2nd Edition. Pages: Publisher: Apress Publishing date: 5 June Language: English.

Author: Mazunris Kelkis
Country: Moldova, Republic of
Language: English (Spanish)
Genre: Environment
Published (Last): 4 November 2015
Pages: 490
PDF File Size: 1.25 Mb
ePub File Size: 20.93 Mb
ISBN: 939-2-85564-127-2
Downloads: 28163
Price: Free* [*Free Regsitration Required]
Uploader: Babei

Learn more about Amazon Prime.

performqnce This should be kept in any oracle technologist’s book shelf. While SQL profiles allow text normalization, stored outlines and SQL plan management do not support the same degree of text normalization. This book bridges the gap between Developers and DBAs and points out indirectly that Performance is a teams effort and solution.

Troubleshooting Oracle Performance, 2nd Edition

The book provides a partial test case that demonstrates the problem. If the array fetch size is set to a value larger than the maximum number of rows in the table’s blocks, the number of consistent gets will be approximately the same as the number of blocks in the table. This is one of best books about oracle performance tuning. East Dane Designer Men’s Fashion.

Physical reads never span several extents. His main interests range from logical and physical database design, to the integration of databases with Java applications, the query optimizer, and basically everything else related to performance management and tuning.


Amazon Advertising Find, attract, and engage customers. Then you can start reading Kindle books on your smartphone, tablet, or computer – no Kindle device required. Nice book for oracle performance tuning.

Christiam author’s use of “up to” should be interpreted at “through” including the specified end-point rather than as “prior to” before the specified end-point. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c.

Troubleshooting Oracle Performance, 2nd Edition – Striving for Optimal Performance

This is because, over the years, plenty of bugs related to it have been found and fixed Over the last several years I have read and reviewed a number of Oracle Database performance related books, including the freely available Performance Tuning Guide that is part of the official Oracle Database documentation. Finding the slow part of an application is often the easy part of the battle. The main idea of gathering system […]. I was delighted by the chapter about the materialized view, it was a revelation.

Updated versions of the scripts are available for download from the author’s website. Commonly, they are caused by the query optimizer evaluating too many different execution plans.

This is a good default value.

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. For the most part the information provided in the book applies to Oracle Database This review is a bit long roughly 18 typewritten pagesand might not completely appear on Amazon see my Oracle blog if the review does not appear in full.


You troubleshoot, of course. Best book for PerformanceTuning experts. Anytime I see a technical book come out with a second or subsequent edition, that’s usually a good sign. I cant see how this book cannot be in your library. Online versions are available on Safari and Google Books.

In contrast, some of the other Oracle Database book authors seem to be more concerned with slamming something onto the page so that something else that is more interesting could be introduced, in the process introducing sentences that can best be described as non-sense. See all 4 reviews. Customers who bought this item also bought.

Antognini’s trroubleshooting of the cost based optimizer makes me think he was involved in developing it. As a result, a child cursor might be incorrectly shared. What an amazing book.