Oracle Core: Essential Internals for DBAs and Developers

by Jonathan Lewis

About the Book: Oracle Core: Essential Internals for DBAs and Developers Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting-no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica Contents Chapter 01.Getting Started... Chapter 02.Redo and Undo Chapter 03.Transactions and Consistency Chapter 04.Locks and Latches Chapter 05.Caches and Copies Chapter 06.Writing and Recovery Chapter 07.Parsing and Optimizing Chapter 08.RAC and Ruin

Genres: Programming

Paperback

First published January 1, 2011

Reviews

[Corrado Piola · Rating 5 out of 5]

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

[Pavel · Rating 4 out of 5]

It's a very hard tech book with lots of binary file dumps.

[Antidb · Rating 5 out of 5]

I read this book years ago when I reversed engineering the redo log structure and data file structure, it helped me a lot.

[Yahoo]

good book