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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory 1st Edition

4.3 out of 5 stars 19 customer reviews
ISBN-13: 978-1565925984
ISBN-10: 156592598X
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$3.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$24.99 On clicking this link, a new layer will be open
More Buying Choices
24 New from $6.62 36 Used from $0.01 1 Collectible from $3.00
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$24.99 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory
  • +
  • Optimizing Oracle Performance
Total price: $56.51
Buy the selected items together

Editorial Reviews

Amazon.com Review

Advanced performance tuning with Oracle involves unraveling the mysteries of the SQL database's inner workings. Oracle8i Internal Services for Waits, Latches, Locks, and Memory peels back several layers of the Oracle onion to reveal how things really work. While the author claims his quest to get to the bottom of Oracle still continues, this book is a snapshot of his current knowledge of the performance-critical internals.

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

About the Author

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 steve.adams@ixora.com.au or via his company's web site at http://www.ixora.com.au/.

NO_CONTENT_IN_FEATURE


Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

Product Details

  • Paperback: 134 pages
  • Publisher: O'Reilly Media; 1 edition (October 21, 1999)
  • Language: English
  • ISBN-10: 156592598X
  • ISBN-13: 978-1565925984
  • Product Dimensions: 6 x 0.4 x 9 inches
  • Shipping Weight: 7.2 ounces (View shipping rates and policies)
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Best Sellers Rank: #1,909,434 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
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!).
Comment 18 of 18 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 15 of 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 9 of 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 8 of 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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!
Comment 7 of 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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!
Comment 7 of 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 7 of 8 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory
This item: Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory
Price: $24.99
Ships from and sold by Amazon.com