Rating:  Summary: Finally .... a book that talks about bottlenecks!!!! Review: I must own every Oracle book ever written so I know how difficult it is to find information on treating the disease instead of the symptoms. Anyone who doesn't find this to be one of the most valuable books in their collection clearly is set in the old school ways of just checking hit ratios. I have followed along with many of the examples and am extremely grateful for the accuracy .... it's as if Gaja & Kirti are working with you. I've already recommended this book to my colleagues and would highly advise it to anyone who not only wants to gain a more efficient approach to tuning but needs a little humor to keep the interest going.
Rating:  Summary: Very Basic and found it lot of other DBA books Review: I thought this book would be great but alas it is same stuff which is found over and over in many books and web pages dedicated to Oracle. I think the matter in the book and cost of the book don't justify. You wouldn't miss anything if you don't own this one. I expected much more from Gaja but it was a disappointment.
Rating:  Summary: Incomplete and basic Review: I was expecting the book to be more advanced in its coverage of tuning topics. The new Oracle8i features such as multiple buffer pools and STATSPACK are not covered properly. There is nothing special in the book and the tuning techniques discussed can be obtained for a number of other Oracle books and documentation. A "101 book" such as this should include some discussion on a "overall system tuning" strategy but nothing like that is in the book.
Rating:  Summary: Tuning For The Masses Review: Many myths surround the tuning of Oracle databases. Some of these myths are legends from old incarnations of the Oracle RDBMS and no longer valid, others have never been right. Oracle Tuning 101 will dispel the myths and put you on the right track for making your systems live up to their potential. As a '101' book, don't expect in depth coverage on Oracle internals, or the finer points of tuning the low level parameters in your operating systems. This book is a holistic approach to tuning, and as such covers the essentials of tuning your Oracle Database systems. Many people think tuning is hard. It isn't. This book will show where to look for performance bottlenecks, and what you need to know to correct them, whether they are in the database, the operating system or the storage system. Many appropriate references are included for texts that will take you into the depths of tuning low level aspects of your system should you choose to do so, but this is not necessary for most tuning issues. And best of all, it is far from a dry read. The writing style will keep you entertained as you learn how to make those databases fly.
Rating:  Summary: It is an eye opener Review: Nobody thinks about bottlenecks that is hanging the system. This book points you in that direction and very successfully. You identify the bottlenecks by following the technics in the book and you are on your way to solve the problem. As a fifteen years veteran working as a developer/DBA I had collected tons of scripts to identify problems in the database. This book changes your mindset, so you run the same scripts dynamically to identify the problem that is degrading your system. The same scripts I used to run are giving me information that clearly identifies the problem that would not be possible if the scripts ran when the process had completed. The book is introductory on the subject. It points you in the right direction. However, to interpret the results, you will need to access documents on the web. Unfortunately much of the information is not in the books. They are in various articles which are posted on the Web. The book has an excellent chapter on Parallelism. Another good chapter is on Optimization. Both of these help you a lot if you want to improve the performance of your system. It is a must read book on the subject.
Rating:  Summary: One of the Good Books from Oracle Press Review: Now a days there are lots of Oracle books confusing (often misleading) the readers and this book definitely not in that list. This is one of the best books from Oracle Press and even better than the other Oracle Press' Tuning books, This book comes from the people who are having real experience in large real time data bases and a must read for any DBA who is interested in becoming a performance Tuner. Hats off to Gaja and Kirti,
Rating:  Summary: First book to profess a Tuning Methodology Review: On my flight back from Mumbai to Chennai, I have completed 50% of the first chapter in "Oracle Performance Tuning 101". My immediate feedback on this book is that, its a great book, just like a novel, very few technical books that you can read and catch your 100% attention on a flight, I enjoyed reading it !
Rating:  Summary: Novel on Oracle Performance Tuning Review: On my flight back from Mumbai to Chennai, I have completed 50% of the first chapter in "Oracle Performance Tuning 101". My immediate feedback on this book is that, its a great book, just like a novel, very few technical books that you can read and catch your 100% attention on a flight, I enjoyed reading it !
Rating:  Summary: A Magnanimous and Bold Work every DBA needs to read !!! Review: Oracle Performance Tuning 101 will change every DBAs thinking about how to diagnose and solve database performance problems in a way which the DBA can understand what is really going on behind the scenes. It is not about black magic or hocus pocus Cache Hit Ratios which do NOT explain the underlying behavior of why the database is waiting and exactly what is it waiting on. This Book helps you understand how to find that wait information, what it means, and some suggestions on how to deal with it. When I first read Chapter 2 of this book, I remembered saying "WOW ... a new era is here on how to track down bottlenecks in the Oracle database, without scratching your head wondering why the database wont go faster after we got some hit ratio percentage back to 99%+". As Gaja, Kirti and John have so eloquently pointed out, tuning is mostly about finding what is competing for the Oracle blocks. In the end, this is causing the wait events and more than likely all tracks lead back to expensive logical I/O and underlying poorly written SQL. For those that have been advocating spending tens of thousands on new hardware or increasing the shared pool ( which actually could cause adverse behavior ) to fix performance issues, YOU need to buy this book and read it. Then YOU need to read it a second time as you would a college text. Every Oracle DBA and every person who has ever wrote a book on Oracle Performance Tuning, should also read and adhere to the principles of this book when attacking slowness in the system/database. Oracle Performance Tuning 101, Statspack and 10046 event data has helped me find and resolve every Oracle Performance problem I have come across since I changed my way of thinking on how to attack Oracle performance problems. A Fantastic and Bold Work !!!!! Great Job Gaja, Kirti and John. Your efforts are to be highly commended in the Oracle world.
Rating:  Summary: Required reading for Oracle Database Tuning Review: Oracle server tuning is getting more sophisticated. You need to understand the reasons the server is waiting, so you can make changes that will cure the problem, rather than guess at the problem and hope your changes are effective. Performance Tuning 101 does an excellent job of teaching you the basics of Oracle server tuning. The authors insert humor which makes the book much easier to read. Study the first 3 chapters intensively and you will really have a grasp of these concepts.
|