Programming Books C Java PHP Python Learn more Browse Programming Books
Qty:1
  • List Price: $24.99
  • Save: $2.77 (11%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
FREE Shipping on orders over $35.
Condition: Used: Very Good
Comment: Eligible for Amazon's FREE Super Saver/Prime Shipping, 24/7 Customer Service, and package tracking. 100% Satisfaction Guarantee.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory Paperback – October 18, 1999

ISBN-13: 063-6920925989 ISBN-10: 156592598X Edition: 1st

Buy New
Price: $22.22
26 New from $6.60 45 Used from $0.01 1 Collectible from $7.66
Amazon Price New from Used from
Paperback
"Please retry"
$22.22
$6.60 $0.01

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student




Frequently Bought Together

Oracle 8i Internal Services: for Waits, Latches, Locks, and Memory + Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)
Price for both: $53.58

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 134 pages
  • Publisher: O'Reilly Media; 1 edition (October 18, 1999)
  • Language: English
  • ISBN-10: 156592598X
  • ISBN-13: 978-1565925984
  • Product Dimensions: 0.4 x 5.9 x 8.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: #2,025,659 in Books (See Top 100 in Books)

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/.


More About the Authors

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

Customer Reviews

4.3 out of 5 stars
5 star
14
4 star
1
3 star
0
2 star
3
1 star
1
See all 19 customer reviews
I highly recommend it for the advanced DBAs out there!
Richard J. Niemiec
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.
Bernie Wong
This book makes you ready for the tuning adventure, cant wait for the next book by steve.
rahul@ratelindo.co.id

Most Helpful Customer Reviews

18 of 18 people found the following review helpful By Ales Kavsek on March 27, 2000
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 15 people found the following review helpful By Daniel J. Peacock on October 16, 2001
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Bernie Wong on March 30, 2001
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 8 people found the following review helpful By James Bullard on February 9, 2000
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Mladen Gogala on May 5, 2000
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Richard J. Niemiec on February 7, 2000
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 8 people found the following review helpful By A Customer on October 7, 1999
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By rahul@ratelindo.co.id on December 5, 1999
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?