Rating: 
Summary: This book is a must for anybody who deals with tuning oracle
Review: An excellent book every Oracle shop should have. It is hard to find a book that at the same time is so rich in technical details, so easy to read, with so many cool and illustrative analogies (e.g. pctfree/pctused comparison to a restaurant), and with a fine human touch. The book has five parts plus Appendices. Part One established the groundwork for the remaining of the book. This is the first book that bases its approach and treats in full Oracle wait event tuning, as opposed to long traditional ratio-based tuning. Part Two deals with Application tuning: optimizers, statistics, access paths. Part Three is devoted to Instance and Database tuning: shared pool, buffer cache, redo log buffer tuning, as well as physical layout tuning: optimal block selection, avoiding fragmentation, partitioning. Part Four is called Specialized Tuning where parallel query and contention tuning are analyzed. Finally Part Five is devoted to "Environment Tuning", i.e. tuning of the OS (few flavors of unix and NT are separately treated) and, as far as I know, the most detailed coverage of RAID in any oracle book. The book is very easy to read, written very clearly and with a lot of humor. Every chapter starts with a related "myth" - a common knowledge that is either false, or not completely true, and ends with an "In a Nutshell" recap of the chapter. The book itself ends with a recap chapter, which in short reviews the whole tuning methodology (yet the RAID tables might have been omitted from this recap). The book has short queries that are illustrating the text, which are not difficult to retype, so the lack of a CD with the code from the book is not a disadvantage. Talking of queries, few more here and there would not hurt. I am not sure whether this is really a beginner ("101") book. Beginners will definitely find valuable stuff there, but for a full enjoyment in the book, and for getting the full benefit from it, I think that experience is very beneficial. A book is fun to read, and it is packed with technical details, interesting observations, and practical advises. It is the first book that fully deals with new emerging oracle tuning methodology: wait events based tuning. It is worth reading every page, and not just flipping through.
Rating:
Summary: If you want to Tune your database, Please read this Book
Review: As 26 years of age and 5 years of Oracle DBA experience, i am not giving Technical philosophy in this review. Life is very short and we have to learn lot. I read this book and I found its complete book on Tuning. I loved this book specially I/O tuning and application tuning are great. Detail explanation on RAID.If you dont read this book yet then you are missing very good book on tuning. Thanks to authors for writting such a good book. It really helps us.
Rating:
Summary: A must have in your Oracle arsenal
Review: As a 101 book, this book should have all the basics, and introductory information needed to get you up and running - and it does. It also has background information - the history of why this works the way it does - to enable me to understand the product and the tools. What I look for in an Oracle book is what, why, and how, and it has to be presented in a way that I can easily absorb. This book has all of that and more. The book is written in a very engaging style, and is well organized. It tells me what I want to know about a topic, a little background on how Oracle came to work the way it does, and then it tells me how to find out what my database is doing, and what I should be doing to fix it. It's a great book. Gaja, Kirti, and John have certainly fulfilled the needs of a 101 book, and gone beyond in many cases. Certainly a must have.
Rating:
Summary: Great diagnostic tool
Review: As a database administrator, I am called on frequently to look at why the database seems to have slowed down. The "Wait State" tools outlined in detail in this book have always provided me with the tools I need to quickly diagnose what is happening within the database. By running four simply queries, I am able to pinpoint the exact problem - meaning exactly which process is the culprit. This is a must buy for every DBA's toolbox. Get it and keep it handy - because you will use it.
Rating:
Summary: Great diagnostic tool
Review: As a database administrator, I am called on frequently to look at why the database seems to have slowed down. The "Wait State" tools outlined in detail in this book have always provided me with the tools I need to quickly diagnose what is happening within the database. By running four simply queries, I am able to pinpoint the exact problem - meaning exactly which process is the culprit. This is a must buy for every DBA's toolbox. Get it and keep it handy - because you will use it.
Rating: 
Summary: Near to Oracle Bible- an eye opener and must for beginners
Review: Excellent Oracle Tuning book!! Real Eye opener. Starts with MYTHS, Clarifies the FACTS and you live with the FACTS(without myths) FOREVER. Written in simple and easily understandable language. Gaja and Kirti have done a marvellous job. Excellent explaination on complex things like Oracle architecture, SGA, Processes, indexes etc. Real life, live examples and sql scripts. Very good notes on various oracle topics. Different level of tuning and explaination on RAID is one of the best things with all other features. A best buy of mine.
Rating:
Summary: A Must Have for Oracle Tuning
Review: Gaja knows his stuff, he is the guru. Tuning 101 clearly defines a method to the madness of Oracle tuning. Dig into the wait events, figure out where and what the problem is. While tuning is a art, a scientific methodology can resolve even the most difficult problem. Great writing style, with a bit of humor thrown in!
Rating:
Summary: A Must Have for Oracle Tuning
Review: Gaja knows his stuff, he is the guru. Tuning 101 clearly defines a method to the madness of Oracle tuning. Dig into the wait events, figure out where and what the problem is. While tuning is a art, a scientific methodology can resolve even the most difficult problem. Great writing style, with a bit of humor thrown in!
Rating:
Summary: Superb book
Review: Gaja's book will educate, entertain and inspire you to learn all about the Oracle "wait interface". I've implemented Gaja's techniques and achieved significant performance gains with problematic SQL and non-optimally tuned Unix and NT systems. This is a must have book for Oracle DBAs and Oracle Developers responsible for database/server tuning.
Rating:
Summary: Hitting Home on Performance Tuning
Review: Gaja, Kirti, and John have found a way to communicate a technical subject in an entertaining manner. They get to the real problem with database performance which is and always has been waiting for resources. It can be used by all levels of Oracle DBA from the novice to the experienced. This is a book that you will use and will not just sit on your shelf.
|
