Apress

Oracle Core: Essential Internals for DBAs and Developers

By Jonathan Lewis

Oracle Core: Essential Internals for DBAs and Developers Cover Image

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.

Full Description

  • ISBN13: 978-1-4302-3954-3
  • 280 Pages
  • User Level: Beginner to Intermediate
  • Publication Date: November 29, 2011
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $39.99
  • eBook Price: $27.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

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

What you’ll learn

  • Oracle's core architectural foundations
  • How much overhead is reasonable
  • How to recognize when you're doing too much work
  • How to predict bottlenecks and why they will happen
  • How to minimise contention and locking
  • Why concurrency can slow things down significantly

Who this book is for

Oracle Core: Essential Internals for DBAs and Developers is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.

Table of Contents

Table of Contents

  1. Getting Started...
  2. Redo and Undo
  3. Transactions and Consistency
  4. Locks and Latches
  5. Caches and Copies
  6. Writing and Recovery
  7. Parsing and Optimizing
  8. RAC and Ruin
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

On page Page 7:

Row 3 instead of varcjar2() it should be varchar2()

On page 2 :
SELECT Statements should be written as
1) & 4 ) Session 1: Select * from t1;

Note the * as otherwise statement will fail !




On page 79:

Bullet point 1 should be:
Delete the only child of parent 1

Bullet point 2 should be
Delete the only child of parent 2


On page 145:
Second paragraph, two lines from end: "..it can unlink them from WRITE_AUX, relink them to REPL_MAIN, and ..."

That should be REPL_AUX, not REPL_MAIN.