• RRP: £19.99
  • You Save: £17.23 (86%)
FREE UK Delivery on book orders dispatched by Amazon over £10.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Oracle 8i Internal Servic... has been added to your Basket

Dispatch to:
To see addresses, please
Or
Please enter a valid UK postcode.
Or
+ £2.80 UK delivery
Used: Like New | Details
Sold by Orion Tech
Condition: Used: Like New
Comment: .
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

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

3.3 out of 5 stars 3 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£2.76
£0.78 £0.01
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more

Man Booker International Prize 2017
A Horse Walks Into a Bar has won the Man Booker International Prize 2017. Learn more
£2.76 FREE UK Delivery on book orders dispatched by Amazon over £10. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

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

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



Product details

  • Paperback: 134 pages
  • Publisher: O'Reilly Media; 1 edition (21 Oct. 1999)
  • Language: English
  • ISBN-10: 156592598X
  • ISBN-13: 978-1565925984
  • Product Dimensions: 15.2 x 1 x 22.9 cm
  • Average Customer Review: 3.3 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 2,150,804 in Books (See Top 100 in Books)
  • If you are a seller for this product, would you like to suggest updates through seller support?

  • See Complete Table of Contents

Product description

Amazon Review

Oracle's databases are probably the most commonly used enterprise relational databases. The latest version, 8i, is rapidly rolling out and this thin book is intended to help you get the most from it.

A complex RDBMS like Oracle can almost be seen as an operating system in its own right, with a kernel controlling all its operations. Steve Adams looks in detail at five different components of this kernel, and how they effect the performance of your databases. You'll find out about how to understand the statistics that you can extract from 4the server, and how you can fine-tune these components to get the most out of a busy server.

Oracle8i Internal Services for Waits, Latches, Locks and Memoryrefers regularly to the author's own set of scripts used to gather information from the Oracle kernel. It's a pity that the source code of these isn't included in the relevant chapters, as they would aid in understanding how you can develop your own tools for acquiring and using Oracle's internal information.

If you want to learn about Oracle, this isn't the book for you, as it deals with complex performance tuning issues. You'll need to be an experienced Oracle administrator to get the most out of this book--and you'll probably want to download the recommended scripts from the O'Reilly web site in order to use them in your own database management scripts. -- SimonBisson

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

See all Product description

Customer Reviews

3.3 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

By A Customer on 8 Dec. 2000
Format: Paperback
If you are already an experienced DBA (or think you are) and are looking for something extra to give you the edge for your next contract then this book is it.
It reveals a lot more about the inner workings of Oracle than the official product documentation or any of the Oracle Press books would dare.
New or trainee DBAs will not get anything out of the book because unlike the Oracle Press door stops, which try to cater for all it is targeted specifically at expert DBAs.
Excellent value for money.
Comment One person 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
By A Customer on 4 Feb. 2002
Format: Paperback
I found the organization of this book confusing - it's not something you can dip into to get useful information about 'real' problems you encounter - you have to read page after page of solid text and read the WHOLE thing before having to go and create your OWN scripts to use the knowledge gained....frustrating...
Comment 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 not for beginners at all.
Maybe in a years time I will have experienced enough to get more from it.
Still a good purchase
Comment 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 Helpful Customer Reviews on Amazon.com (beta) (May include reviews from Early Reviewer Rewards Program)

Amazon.com: 3.7 out of 5 stars 19 reviews
3 of 3 people found the following review helpful
5.0 out of 5 stars Focused on a single topic and covers it exceptionally well 3 July 2001
By Mike Tarrani - Published on Amazon.com
Format: Paperback Verified Purchase
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.
18 of 18 people found the following review helpful
5.0 out of 5 stars Excellent book on internal services! 27 Mar. 2000
By Ales Kavsek - Published on Amazon.com
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!).
2 of 2 people found the following review helpful
5.0 out of 5 stars Good look into Oracle internals 28 July 2004
By Tatjana Injac - Published on Amazon.com
Format: Paperback Verified Purchase
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 pretty well. I especially liked the chapter on Memory.

I learned a lot from this book. This was money well spent.

Highly recommended.
5 of 22 people found the following review helpful
1.0 out of 5 stars All theory, no meat 13 Mar. 2000
By Abed T. Benbrahim - Published on Amazon.com
Format: Paperback Verified Purchase
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. I did not get any practical information out of this book. At a 120 pages, it makes for a nice bedtime fairy tale. This is definitely the worst O'Reilly book I have ever seen (I own 16 of them).
7 of 7 people found the following review helpful
5.0 out of 5 stars Excellent Work! 7 Feb. 2000
By Richard J. Niemiec - Published on Amazon.com
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!
Were these reviews helpful? Let us know