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: Kazikora Gum
Country: Honduras
Language: English (Spanish)
Genre: Automotive
Published (Last): 12 June 2016
Pages: 355
PDF File Size: 13.75 Mb
ePub File Size: 16.10 Mb
ISBN: 419-2-67636-401-6
Downloads: 70013
Price: Free* [*Free Regsitration Required]
Uploader: Gardaktilar

About the Author SinceChristian Antognini has been focusing on understanding how the Oracle database engine works. For the most part the information provided in the book applies to Oracle Database The rule is that fhristian a table is referenced in a hint, the alias should be used instead of the table name, whenever the table has an alias.

Another reason to buy it! However, the “filtered” word in the statement seems to suggest that selectivity represents the fraction of the rows removed by an hroubleshooting, rather than the rows that survived the filter at an operation. For example, a comment added before a hint invalidates it.

The author’s use of “up to” should be interpreted at “through” including the specified end-point rather than as “prior to” before the specified antognibi. Full table scans, full partition scans, and fast full index scans executed in parallel use direct reads and, therefore, bypass the buffer cache. You won’t be able to follow the book without the code.


Foreword from the First Edition.

Follow the Author

Write a customer review. This book correctly states: This site uses Akismet to reduce spam.

Things are explained clearly and you can download the code that is used in the book to run the examples yourself. Information is in bits and pices. What other items do customers buy after viewing this item?

Best book for PerformanceTuning experts. Christian Antognini brings a decade and a half experience to his topic. 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.

Troubleshooting Oracle Performance, 2nd Edition

Such a view is called a nonmergeable view. Page of the book also states that the rule based optimizer has been desupported.

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. It is thus recommended to view the scripts and experiment with those scripts while performancce book is read.

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 perfodmance the original. As was the case for the first edition of this book, there are several factors that separate this book from the other broad-ranging Oracle Database performance books on the market: 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.


Commonly, they are caused by the query optimizer evaluating too many different execution plans.

Troubleshooting Oracle Performance – Christian Antognini – Google Books

These two books may be all I’ll ever need on this subject. This is an excellent book on Oracle Performance Trouble Shooting. Amazon Inspire Digital Educational Resources. I’ve been performznce Oracle DBA for 11 years now this is the only Oracle book I read I google for the other small things that I don’t care to remember or don’t know.

The number of executions itself is provided by the Number of plan statistics captured value. This does not appear to be a significant problem christiam the essential portions of the script appear in the book. This is one of best books about oracle performance tuning.

Anytime I see a technical book come out with a second or subsequent edition, that’s usually a good sign. Troubleshooting Oracle Performance Paperback.