Buy New
  • List Price: $39.99
  • Save: $9.87 (25%)
FREE Shipping on orders over $35.
In Stock.
Ships from and sold by
Gift-wrap available.
Add to Cart
Want it Tuesday, April 22? Order within and choose One-Day Shipping at checkout. Details
Trade in your item
Get a $12.49
Gift Card.
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

Oracle Core: Essential Internals for DBAs and Developers Paperback

ISBN-13: 978-1430239543 ISBN-10: 1430239549 Edition: 1st

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
"Please retry"
"Please retry"
$28.99 $30.09


Frequently Bought Together

Oracle Core: Essential Internals for DBAs and Developers + Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press) + Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
Price for all three: $102.62

Buy the selected items together


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 280 pages
  • Publisher: Apress; 1 edition (November 22, 2011)
  • Language: English
  • ISBN-10: 1430239549
  • ISBN-13: 978-1430239543
  • Product Dimensions: 9.2 x 7.5 x 0.6 inches
  • Shipping Weight: 1.1 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Best Sellers Rank: #330,714 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Jonathan Lewis has been working in the�information technology�industry for nearly 25 years, and has been using the Oracle relational database management system for more than 20. For the past 16 years, he has�worked as a freelance consultant, often spending only one or two days at a time with any client to address critical performance problems. He also advises on design and implementation problems, and on how to make best use of the most appropriate Oracle features for a given project. Jonathan is also renowned throughout the world for his tutorials and seminars about the Oracle database engine and how to make best use of it. Having visited 42 countries at�last count, his exceptional ability has earned him an O1 visa from the United States, allowing him to do consultancy and lecture work there. Jonathan has written two books about Oracle (Practical Oracle8i, Addison-Wesley, 2000; Cost-Based Oracle Fundamentals, Apress, 2005), and has contributed to two others (Oracle Insights, Apress, 2004; Oracle Database 10g New Features, Oracle Press, 2004). He also writes regularly for the UKOUG magazine, and occasionally for other publications around the world. In the limited amount of time he has leftover, Jonathan also publishes high-tech Oracle articles on his blog at

Customer Reviews

4.8 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 16 customer reviews
The book is extremely readable and understandable even for non-native engl. speakers.
daniel zika
Certainly the best book on Oracle internals since Steve Adams book (Steve has unfortunately left the field).
Richard L. Rankin
Finally, I strongly recommend this book to everyone who wants to learn more, and more, and more...
Corrado Piola

Most Helpful Customer Reviews

26 of 30 people found the following review helpful By Charles Hooper on December 25, 2011
Format: Paperback Verified Purchase
I pre-ordered a paperback copy of this book three months ago from Amazon and also purchased a PDF copy of the book from Apress. It was a long, nearly six year wait since the publication of the author's "Cost-Based Oracle Fundamentals" book, and I am fairly certain that many of those who read the "Cost-Based Oracle Fundamentals" book were looking forward to reading volume two in the anticipated three part series.

The author of this book is a well known Oracle Ace Director who has written at least three books since the year 2000 and contributed to a handful of other books. In addition to writing books, the author has also maintained a technical Oracle Database blog since 2006, and contributed to a number of Oracle focused Internet forums (Usenet, Oracle-L, AskTom, Oracle OTN) dating back to at least 1994. The book's primary technical reviewer is also a well known Oracle Ace Director and Oracle Certified Master who also maintains a technical Oracle Database blog and "living" Oracle reference site with deeply technical articles.

Did the book's contents meet the level of expectations provided by the book's cover and the publisher's description of the book? Shortly before the book arrived, I assumed that the book was targeted at people who might have struggled with the "Cost-Based Oracle Fundamentals" book. The back cover of this book states that the book targets readers with knowledge ranging from beginners to intermediate. I was surprised to find that chapter one lasted all of four pages, and that page seven introduced the reader to the first of many symbolic block dumps.
Read more ›
1 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
5 of 5 people found the following review helpful By RodL on June 9, 2013
Format: Paperback
Charles Hooper has provided an excellent technical review of this book.
I would also agree with the reviewer below who points out that it really is for advanced developers and DBAs. It is not for the faint-hearted (or for intermediate users).
However, none of the reviewers below have addressed the major problem with this book - its readability. I refer not to the technical content (which is of course well up to the usual standard of Jonathan's books and others published by Apress). But why oh why did JL/Apress decide to:
(a) use a smaller font for this book (as compared with the usual font in say 'Tales of the Oak Table' and Antognini's excellent 'Troubleshooting Oracle Performance' or even his own 'CBO Fundamentals')
(b) reduced spacing between paragraphs?
This all makes this book so much harder to read (so that it is rather like wading through a student thesis). Which is a pity - because JL's work is usually so readable and informative, but for this book the poor formatting really is an unnecessary hindrance.
I suggest that you wait until a new version of this book is published with the usual Apress font and spacing - but I suspect that this will not happen...
1 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
11 of 14 people found the following review helpful By Richard L. Rankin on February 20, 2012
Format: Paperback Verified Purchase
Certainly the best book on Oracle internals since Steve Adams book (Steve has unfortunately left the field). I remember a friend with a PhD in math and a chess master who felt intimidated by Jonathan's "Cost-Based Oracle". What makes is work more impressive is that it it based on personal investigation - dumps and testing. It is unfortunate that Oracle Corporation, in it's pursuit of galactic domination, has closed many doors to information and has threatened writers with "attempting to reverse engineer their product". Fewer and fewer technical papers come out of Oracle every year. The RDBMS, application software, training, consulting... May I use the word "monopoly"? I want to create BI software/hardware that uses Oracle. Do you seriously think Oracle wants to help me? Bill Gates is trying to eradicate childhood diseases, Larry Ellison is trying to eliminate anyone not generating income for him. If I weren't so lazy (one of Larry Wall's virtues of a programmer), I'd switch to SQL Server or dive into the noSQL fray. Pardon the flame there. It's a very good 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
3 of 3 people found the following review helpful By C. W. Lawson on July 24, 2013
Format: Paperback Verified Purchase
Yes, I was shocked by this book. Had absolutely no idea it would be as comprehensive as it is. Where does this guy get the time to do all this research? I agree with other reviewers who suggest this book sets the standard for Oracle internals. This book is definitely one of a kind.

The greatest value for me was Chapter 3, "TRANSACTIONS AND CONSISTENCY." I was investigating performance issues with a flashback query, and this chapter had the answer. It was due to the "Transaction Table" rollback. I have not found this valuable information anywhere else. There was not one DBA amongst the 24 I work with who knew this information (I admit I certainly did not.) The author gave me several good tips on how to identify when your database is performing lots of transactions table rollbacks. This was all excellent and very practical.

The main suggestion I have is on the writing style. The effort required to read this book is formidable. That is what kept me from giving the book six stars, instead of just five. Here's the point--we techies have difficulty presenting complex subjects in an understandable fashion--we just want to get into the details, and not waste time on preliminaries. That's why presentations by techies at conferences are often terrible and unreadable. (To clarify, I've attended talks by the author, and he does NOT make that mistake at conferences.)

When discussing a complex topic, the text sometimes goes quickly into very detailed specifics, with just a sketchy overview beforehand. The author is so anxious to get into the nitty gritty data, he doesn't give us a chance to catch up with him. This makes it tougher for mere mortals to follow Mr Lewis.
Read more ›
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

Product Images from Customers

Most Recent Customer Reviews