The book's title tells the whole story about its content. It focuses on waits, latches, locks, and memory allocation because they have a dramatic effect on overall performance. Each of these topics is presented separately, with explanations of how each works under the hood and what can be done to optimize it. Although the title offers plenty of architectural explanation, a solid foundation into Oracle 8i release 8.1 (the version addressed by the author) is a prerequisite for understanding this text.
The presentation includes few diagrams. Instead, the author makes a special effort to list relevant Oracle parameters and their descriptions in tables, as well as examples of statistics that can be used in optimization. This is a guide for advanced administrators already on a solid footing with Oracle8i and offers plenty of insight into the crucial undocumented aspects of the relational database. --Stephen W. Plain
Steve Adams runs a small consulting company, Ixora, that specializes in advanced Unix and Oracle performance tuning. He is based in Sydney, Australia, but also works remotely for clients in America and Europe. Steve is a regular contributor to various Oracle discussion forums on the Internet, where he is widely regarded as the leading performance expert. His experience with Oracle dates back to version 3 (1984). However, most of his work has been in Unix performance tuning. His interest in Oracle--and Oracle internals in particular--was rekindled when working as the Unix performance expert on a benchmark of an Oracle-based application in 1995. He found the challenge of understanding Oracle performance to be extremely demanding, and yet irresistible. Steve doesn't yet claim to have mastered the topic of Oracle performance, but he does have plenty of insight to share. He can be contacted directly at firstname.lastname@example.org or via his company's web site at http://www.ixora.com.au/.
I highly recommend it for the advanced DBAs out there!
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.
This book makes you ready for the tuning adventure, cant wait for the next book by steve.
Yes, the book was written when Oracle 8i was around, but it is well worth the read even today.
Adams knows how Oracle works and explains the waits, latches and locks... Read more
Wait events are often the key to understanding 'what is going on' when Oracle performance problems occur during run time. Read morePublished on September 25, 2003 by Jason
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.Published on November 12, 2002 by Manoj Kumar
Steve Adams has collected and assembled a compendium of facts about a difficult aspect of Oracle: waits, latches, locks and meemory. Read morePublished on July 2, 2001 by Mike Tarrani
This book does not really go too deep into Oracle internals. More information on the subject is available anyway from metalink or white papers. Read morePublished on January 12, 2001 by krishd
If you want to know about how oracle works, you have red the concepts manual and want to learn more, its the best book for you. Read morePublished on November 23, 2000 by Barto
To research, test and explain such great detail of information that has never been done by anyone before explains the dedication, knowledge and experience of the author. Read morePublished on June 19, 2000 by Murali Vallath
There is a lot of theory (really a lot of conjectures since none of the theories expounded have been documented by Oracle) in this book and no meat. Read morePublished on March 12, 2000 by Abed T. Benbrahim