June 16, 2020 0 Comments

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: Niran Daisida
Country: Gabon
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 4 September 2010
Pages: 479
PDF File Size: 11.90 Mb
ePub File Size: 13.14 Mb
ISBN: 831-2-55124-418-8
Downloads: 83852
Price: Free* [*Free Regsitration Required]
Uploader: Zuluzahn

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.

SinceChristian Antognini has been focusing on understanding how the Oracle database engine works. His main interests range from logical and physical database design, to the integration of databases pertormance Java applications, the query optimizer, and basically everything else related to performance management and tuning.

If he is not helping one of his customers to get the most out of Oracle, he is somewhere lecturing on optimization or new Oracle database features for developers.

Would you like to tell us about prrformance lower price? If you are a seller for this product, would you like to suggest updates through seller support? Read more Read less. Discover Prime Book Box for Kids. Customers who viewed this item also viewed. Page 1 of 1 Start over Page 1 of 1. Customers who bought this item also bought. About the Author SinceChristian Antognini has been focusing on understanding how the Oracle database engine works.

Expert’s Voice in Oracle Paperback: I’d like to read this book on Kindle Don’t have a Kindle? Share your thoughts with other customers. Write a customer review. Showing of 9 reviews.

Troubleshooting Oracle Performance – Christian Antognini – Google Books

Top Reviews Most recent Top Reviews. There was a problem filtering reviews right now. Please try again later. This is an excellent and very helpful book which employs a systematic approach and interesting wrtiting style to keep the reader interested. I was delighted by the chapter about the materialized view, it was a revelation.

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 yroubleshooting specialist most likely would refer this book again and again. One person found this helpful.

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. It was the best my decision. It is quite clear that a great deal of effort was made by the author to carefully verify the tips and test results contained in the book and to organize the material in a logical progression, thus building a bridge between the reader’s current understanding to the understanding of complex tuning approaches.

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 chriwtian 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 Iracle 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 or more pages, and likely would have been obsolete by the time it was published.


The “Troubleshooting Oracle Performance” book seems to assume that the Oracle database concepts are well understood. The original review is quite limited in depth compared to some of my more recent Oracle Database book reviews. I recently decided to purchase the companion PDF file from Apress, as well as to re-read the book so that I could provide a much more detailed book review.

Since the time when I wrote my original review of this book I have formally reviewed at least three other books that are Oracle Database performance specific, reviewed a handful of other books that contain Oracle Database performance sections, and briefly viewed and wrote comments about a couple of other performance related books. The “Troubleshooting Oracle Performance” book effectively sets the standard by which all other Oracle Database performance books are measured.

The depth of coverage, accuracy of contents, and signal to noise ratio are unparalleled in the Oracle Database performance book category. There are several factors that separate this book from the other Oracle Database performance books on the market: Very few potential problems were overlooked.

Some of the other books on the market only describe troubleshhooting potential benefits of implementing a feature, without discussing limitations or unintended side-effects. The book commonly describes how to accomplish a task in the current Oracle Database release, as well as older releases, if the approach differs.

Some of the xhristian books on the market inter-mix features and behaviors in various Troubelshooting Database releases, without clearly distinguishing what will and what will not be available in the reader’s environment. The book uses a “demonstrate and test in your environment” approach from cover to cover.

The downloadable scripts library is extensive, and often contains more performance information than what is presented in the book. It is thus recommended to view the scripts and experiment with those scripts while the book is read. The downloadable scripts on the Apress website appear to be corrupt this corruption appears to affect more than just the scripts for this book. Updated versions of the scripts are available for download from the author’s website.

Troubleshooting Oracle Performance, 2nd Edition

In contrast, other books seem to take the approach of “trust me, I have performed this task 1, times and never had a problem” rather than the “demonstrate and test in your environment” approach as was used in this book.

Additionally, the information is well organized into a logical progression of topics, rather than each section of the book appearing as an island of unrelated information. 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 end-point.

It appears that the author exercised great care when presenting his information on each page. 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.

The “Troubleshooting Oracle Performance” book covers Oracle releases through 9. For the most part the information provided in the book applies to Oracle Database The author’s website effectively extends the book’s contents to cover Oracle Database It is recommended that the Oracle sample schemas are installed in a test database so that the reader is able to experiment with all of the sample scripts provided with the book.

The book appears to be mostly directed at DBAs, however sections of the book are appropriate for developers. 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.

The default behavior in This statement probably could have been clarified slightly, repeating what was stated earlier about the cumulative nature of the statistics for the parent and child operations. The rule based optimizer still exists in the latest release of Oracle Database, but its use is deprecated, and therefore the use of the rule based optimizer is no longer supported by Oracle Corp.


Page of the book also states that the rule based optimizer has been desupported. Portions of the table may remain cached in the buffer cache between each execution a warning about this potential issue is provided in the book immediately after the script. The query optimizer may decide to use serial direct path reads “direct path read” wait eventrather than the commonly expected “db file scattered read” type accesses for the full table scan.

Serial direct path reads where introduced in Oracle Database What unrelated blocks are in the buffer cache at the time that the test started might be important.

Ideally, the book would have mentioned that there are risks that hints will be ignored by the optimizer when adding regular comments to hint blocks, especially when the comments are added in front of the hints. This is one of the very few instances where the licensing requirements for a feature are not mentioned in the book when the feature is introduced.

The licensing requirements are described two pages later. This does not appear to be a significant problem because the essential portions of the script appear in the book. Full table scans, full partition scans, and fast full index scans executed in parallel use direct reads and, therefore, bypass the buffer cache. However, Oracle Database The book author briefly mentions this feature in one of his blog articles.

Since the time when the book was published, the author created a blog article that demonstrates how to use direct path insert for SQL statements that have a VALUES clause. According to the blog article, the behavior changed in Oracle Database This was attributed to a user’s loss of attention because of longer wait times.

PerformaSure, JProbe; load-testing framework: This occurs even if they are incompatible with each other. This is a good default value. As of Oracle Database 11g, this can be changed if necessary. Physical troibleshooting never span several extents. The book provides a partial test case that demonstrates the problem. This book correctly states: Because of this, it is used to push the utilization of these operations.

Such a view is called a nonmergeable view. The book provides three references to other sources to help the reader understand trace file contents. In other troubleshootiny, it is antogniini that impels toward an action, not merely suggesting one. This is because, over the years, plenty of bugs related to it have been found and fixed. Therefore, my advice is to carefully test applications when cursor sharing is enabled. If the array oracl 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 antognimi the table.

Instead, it is referenced by a logical rowid.

This kind of rowid is composed christiah two parts: This is possible if no columns are selected from the linked table, and a validated foreign key links to the table from the other tables specified in the SQL statement. With all the 5 star reviews, I was excited to get my copy and was disappointed with the contents.