Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach (Expert's Voice in Oracle) 2011th Edition
Use the Amazon App to scan ISBNs and compare prices.
Featured Functional Programming Titles
Check out these featured titles from O'Reilly Media and distributed publishers.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
The authors of this book all have at least 10-15 years of experience with Oracle Database (and likely several years of IT related experience prior to that), are accomplished writers of several books (at least three of the "Recipes" books were co-authored by this book's authors), and at least two of the authors teach at the university level. The technical reviewer of the book is an Oracle Ace with an OCP certificate and also has an Oracle Certified RAC Expert certificate. Apress, based on my past experience, publishes some of the best Oracle Database material on the market. All of the critical recipe elements for a very successful, extremely useful book were initially in place for this book.
So, how well did the book's final contents meet the level of expectations provided by the book's front cover and the publisher's description of the book? Simply put, some of the chapters appeared as though someone tried to hammer a square cut nail into a finely machined and tapped machine-screw hole. The end result shows that the topic of performance tuning Oracle Databases simply does not fit well into a recipe format. The number of technical/logical errors per page in some of the chapters makes for a difficult challenge to find any useful/reliable information in those chapters without spending significant time verifying that the material presented by the book is accurate.Read more ›
In my opinion, a DBA (or a developer) with 0 - 3 years of experience can expect the following after reading this book
1. Know what to do when a 3 page query is dropped in their lap for tuning (trust me, trying to convince the user the problem is with the network, or their
machine, or with them !!! does not work after a couple of times :)')
2. not be intimated to read and to analyze an AWR report
3. can incorporate performance related daily checks in their day-to-day activities
4. can actually answer the typical performance related interview questions (e.g. how to tune an instance, how to tune a query, etc)
5. have the background to read advanced performance tuning literature
Following are some suggestions for the subsequent editions of this book
Chapter 8 "Creating Efficient Sql" adds no value and can be scratched in favor of the following topics
1. Sql Plan Management (after all, one of the authors has talked extensively about it in their "Oracle Database 11g" book)
2. Local vs Global indexing (when to use them, how to create them, etc.)
3. Why, which (local vs global), and how often to collect object level statistics
4. Highlight the performance tuning similarities and differences between OLTP and OLAP systems
I am almost tempted to add "RAC Performance Tuning" to my wishlist, but it might be an advanced topic?
In summary, I would recommend this book to anybody wanting to get started on Oracle performance tuning
Most Recent Customer Reviews
This is a book with valuable technical experiences about oracle 11g database issues, how prevent it and how deal with tuning problemsPublished on February 17, 2014 by Nelba Sanchez
This is book is useful for quick references, commands etc. Not that good for deeper explorations. It can helped a lotPublished on March 31, 2013 by jitender
This book provides good coverage of common performance tuning problems and descriptions of how to tackle each issue. Read morePublished on December 7, 2011 by Roger57