Troubleshooting Oracle Performance by Christian Antognini, PDF 1430221755

Troubleshooting Oracle Performance

  • Title: Troubleshooting Oracle Performance
  • Autor: Christian Antognini
  • Publisher (Publication Date): Apress; 2008 edition (November 1, 2008)
  • Language: English
  • ISBN-10: | 1430221755
  • ISBN-13: | 978-1430221753
  • File Format: EPUB, PDF


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.

No reviews


“Troubleshooting Oracle Performance” is the most thorough, yet physically compact book covering performance tuning with Oracle 9i R2 through 11g R1 on the market. 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 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. As such, it is probably wise to read “Expert Oracle Database Architecture” first, followed by this book, “Cost-Based Oracle Fundamentals”, and finally “Forecasting Oracle Performance”. —– I originally reviewed the “Troubleshooting Oracle Performance” book a bit over three years ago, having pre-ordered the book prior to its publication. 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: * For every feature that is described to help solve a problem, as many as possible of the benefits are listed, and an equal amount of attention is paid to the potentially wide-ranging problem areas of various solutions. Very few potential problems were overlooked. Some of the other books on the market only describe the potential benefits of implementing a feature, without discussing limitations or unintended side-effects. * For nearly every feature described in the book, the book lists the licensing and version requirements (sometimes to a specific point release such as,,, that are required so that the reader is able to take advantage of the feature ¨C these requirements are often listed early in the description of the feature. 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 other books on the market inter-mix features and behaviors in various Oracle Database releases, without clearly distinguishing what will and what will not be available in the reader’s environment. * While many strong statements are made about Oracle Database in the book, there is no “hand waiving”, and there are very few inaccurate statements. 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. In contrast, other books seem to take the approach of “trust me, I have performed this task 1,000 times and never had a problem” rather than the “demonstrate and test in your environment” approach as was used in this book. * Information in this book is densely packaged, without unnecessarily repeating information, and without giving the impression that sections of the book are a paraphrase of some other set of articles. 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 well-placed graphics throughout the book support the contents of the book, rather than distract from the information that is described. * In the acknowledgments section at the beginning of the book the author mentioned that his English writing ability is poor and that “I should really try to improve my English skills someday.” In the book the only hint that English is not the author’ primary language is the repeated use of the phrase “up to” when describing features that exist in one Oracle Database release version or another. 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

Related posts

Social Media Strategy For Businesses: Learn How To Build Awareness, Increase Sales & Create A Community Of Brand Loyalists (CoolREADS) by Elisabeth (Lis) Thomas, PDF 0998792527
Windows Stack Exploitation 2 by Mr Samuel Huntley, PDF 1542405017
Python Business Intelligence Cookbook by Robert Dempsey, PDF 178528746X
Satellite Network Threats Hacking & Security Analysis: Satellite Network Hacking Security Analysis ,Threats and Attacks , Architecture Operation design and technologies by Adam Hudaib, PDF 1535252545
Modelling Intelligent Multi-Modal Transit Systems by William H. K. Lam, PDF 1498743536
Python GUI Programming Cookbook – Second Edition: Use recipes to develop responsive and powerful GUIs using Tkinter by Burkhard A. Meier, PDF 1787129454

Leave a Reply

Your email address will not be published. Required fields are marked *