Oracle Core: Essential Internals for DBAs and Developers and over one million other books are available for Amazon Kindle. Learn more

Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases) 2011th Edition

19 customer reviews
ISBN-13: 978-1430239543
ISBN-10: 1430239549
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.
Sell yours for a Gift Card
We'll buy it for $11.46
Learn More
Trade in now
Have one to sell? Sell on Amazon
Try the eTextbook for free
$0.00
Buy used
$30.04
Buy new
$36.94
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, November 22, 2011
"Please retry"
$36.94
$28.58 $30.04
More Buying Choices
23 New from $28.58 13 Used from $30.04
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Rent Textbooks
$36.94 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

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

Buy the selected items together

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 jonathanlewis.wordpress.com.
NO_CONTENT_IN_FEATURE


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

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

Customer Reviews

Most Helpful Customer Reviews

33 of 39 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
9 of 9 people found the following review helpful By Bassocantor TOP 50 REVIEWER 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
5 of 6 people found the following review helpful By Corrado Piola on August 31, 2012
Format: Paperback Verified Purchase
Every Oracle expert knows Jonathan Lewis and all his work about internals.
His books, like "Practical Oracle 8i" and "Cost-Based Oracle Fundamentals", and the so many documents that you can find in the web, are really a must for everyone who wants to learn how Oracle works under the covers.
Oracle Core is simply perfect. It explains very well how transactions work and how locks and latches are acquired and managed.
You can learn the internal structure of the Database Buffer Cache, the Library Cache and how are implemented the LRU algorithms.
Undo and Redo mechanisms are really well cleared and they constitute my favourite Chapter in the book.

I think that the User level declared for the book (Beginning-Intermediate) is not really correct.
I don't want to say that a Beginner cannot read it, but I think that a Beginner may lose some important details that make this book simply unique.
I suggest a previous reading, to well understand the Oracle architecture and get the right background (Tom Kyte's book "Expert Oracle Database Architecture" is a perfect and detailed resource).
Infact, this book cannot explain some basics (this is a 250 pages book) because it's not been written for that scope.

Finally, I strongly recommend this book to everyone who wants to learn more, and more, and 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
2 of 2 people found the following review helpful By daniel zika on March 4, 2014
Format: Paperback Verified Purchase
The book is extremely readable and understandable even for non-native engl. speakers. It gives a lot of insights and facts of how things work in a perfect way, as author says "in circles".
It doesn't make one better programmer, but helps one to understand what his/her code does ( or might do ) and why ( or why it can't ). I like are the summaries at the of each chapter, refreshers before next topic.
From my developer's point of view I can recommend the book to all who want not just to write a pl/sql code, but want to understand why Oracle is behaving the way it does.
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

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 Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)
This item: Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)
Price: $36.94
Ships from and sold by Amazon.com