Customer Reviews

Oracle8i Internal Services for Waits, Latches, Locks, and Memory

5 star:		(14)
4 star:		(1)
3 star:		(0)
2 star:		(3)
1 star:		(1)

 

 

In five years of being Oracle DBA I never had to tune databases on such level that I would have to know internals on the level described in this book; knowing what's really going on behind all those fancy statistics, using hidden parameters, events or X$ tables directly. I guess I was lucky so far. I think that this book is a must read for *any* DBA!

Having several books about tuning Oracle server on my bookshelf not a single one goes deeper in the explanation than this thiny one. We can only imagine and appreciate the time and knowledge that Steve Adams invested in this book.

One reminder to those of you who are searching for the definitive tuning guide ("do that, change that..."); Oracle8i Internal Services is not about that, here is what author wrote in the preface ..."My advanced Oracle performance-tuning book is still a dream. This little book is something else: an introduction to Oracle internals. It builds the foundation necessary for advanced performance tuning..."

There is only one thing that this book badly need - pictures! So Steve if you're reading this please include some pictures in your second edition (I hope there would be one!).

I'll admit, this book made my head hurt the first time I read it, and I consider myself to be pretty well versed in Oracle. Steve does a fantastic job explaining some of the internal workings of the database. He dispells many of the "tuning" myths associated with locks and latches and touches on using Oracle's wait statistics, which has become a foundation for a new and better approach to tuning the database. If you are DBA that is interested at all in the internal workings of the database, or need a reference to help in your tuning efforts, get this book.

An excellent, must-read book on internal waits for experienced DBAs and performance engineers. Some reviewers gripe that a lot of the information can be found in MetaLink - that is true, but you have to weed through a lot of disconnected discussions. I found this book very useful because it has great depth, is well organized and is a great springing board to further research into other sources - including MetaLink. Excellent work Steve. I can't wait for any follow-on books.

I find this book to be very helpful diagnosing obscure errors as well as less defined parameters found in various v$ views and report.txt. Steve, has obviously worked very hard to provide useful information and guidance for those of us not privy to Oracle internals. Looking forward to the next edition.

An excellent, very concise book covering the internal mechanisms for locksand latches in Oracle8i. Written clearly and with the level of details that sufficient not only to clarify those otherwise arcane mechanisms of Oracle RDBMS but also to be of immediate practical use. I am a long time Oracle DBA (started with the version 4) and I still learned quite a few things from Steve Adams. Congratulations, Steve and keep up the good work!

This is a well done and well written advanced book on tuning at the lowest level of Oracle. I highly recommend it for the advanced DBAs out there! Great job Steve!

This book is tragetted to readers who are interested in Advanced Performance Tuning. This speaks about what oracle does behind the doors. Its targetted to people who are interested in learning internals of Oracle database engine.

Any sincere oracle Professional know the name of steve adams. Any expert on oracle pays a visit to his site. so think for a moment in silence and buy the book.

The first book i have read which explains the "why" part of the tuning, not just the "do this to achieve that" thing. This book makes you ready for the tuning adventure, cant wait for the next book by steve. One minus point is the lack of diagrams to help understand the memory structures better.

Steve Adams has collected and assembled a compendium of facts about a difficult aspect of Oracle: waits, latches, locks and meemory. His clearly written explanations will not only provide DBAs with an in-depth understanding of how these fit into the overall scheme of Oracle's design, but also will allow them to troubleshoot and resolve problems that would exasperate all but the demi-gods. Although the book would have benefited from a lot more than the two illustrations he saw fit to provide, his generous use of tables goes a long way towards making an obtuse subject clear. I would have liked more examples than the outputs he uses to show results of queries, but the lack of illustrations and better examples did not prevent me from undertanding every topic presented.

My wishlist notwithstanding, this book merits five stars because it provides a wealth of information and knowledge that you just can't find elsewhere. If you're an Oracle DBA you need this book.