Expert Oracle Database Architecture. 9i and 10g Programming Techniques and Solutions

Editorial Review

This book will help you make the best use of Oracle technology. Emulating Tom's rational methodology, and demand for proof-by-example, will make you a far better technology thinker. Without question, this is one of the most importantly Oracle books you can possess.

— Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:

Files, memory structures and processes
Locking and latching
Transactions, concurrency and multi-versioning
Tables and Indexes
Datatypes
Partitioning and parallelism

Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.

Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you.

In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

Cached date: AWS Called=true

Customer Reviews

Brilliant book, useful for all database developers, not just Oracle

2008-04-24
Wow, could this be the best computer book ever written? Well, if you are using Oracle and you want to understand how Oracle works, it just might be. It's packed with performance information, and even if you are not using Oracle this will be helpful for any (esp for Postgres users)

Mandatory Reading for Oracle Developers & DBA's

2008-03-29
This is hands down the best book I've read on Oracle. It should be mandatory reading for anyone working with an Oracle database. Period.

I have close to 15 years of experience with Oracle, and have designed and developed large scale (>1TB) transactional systems. I've worn the hats of DBA, architect, developer, consultant, etc. The information in this book is invaluable.

Great book

2007-09-19
This book is accurate and undoubtfully an excellent source to learn more about the Oracle Database.
Tom is an author full of humor with a versatile approach to performance. In his book he shows his approach to performance and put light on common practice like database independence and read-write consistency or like constraints enforced by triggers and autonomous transaction.
No doubt I learned a lot in this book!

the right approach

2007-07-29
I actually helps you understand, rather than just throwing information at you (as many books do)

Very Good Oracle Architecture Reference Manual

2007-06-11
If you work with Oracle this is a manual you need on your desk. Not just for DBA's but also for developers who will derive a good insight into how they should be developing their code.
Very technical but not to the point that brain freeze occurs.
Would highly recommend it.

Oracle architecture explained simply

2007-05-11

This book will help you make the best use of Oracle technology. Emulating Tom's rational methodology, and demand for proof-by-example, will make you a far better technology thinker. Without question, this is one of the most importantly Oracle books you can possess.

— Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation

Files, memory structures and processes
Locking and latching
Transactions, concurrency and multi-versioning
Tables and Indexes
Datatypes
Partitioning and parallelism

Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.

Such a practially useful book!

2007-05-07
My company was doing a 15 million dollar national project using Oracle. There were some very complicated and intense database algorithms. We hired a famous Oracle consultancy firm. The DBA who assisted me with all the design and performance benchmarking recommended this book to me. After I had a look, I realized that most of the techniques he used came from this book! Such a practically useful book!!

It does not talk about the theories and principles of Oracle, like all other thousands of "ordinary" books do. By reading those books you know "WHAT" Oracle is, but you don't easily relate it to your own business - when you face a certain problem, what you should do? What you should avoid? While this book addresses this domain.

I found reading each page and chapter virtually fun! I am not a computer nut who have no friends and family and work before his computer 18 hours a day. Yet I have fun and smiles every now and then when reading this Oracle book! Amazing!

Expert Oracle Database Architecture 9i and 10g Programming Techniques and Solutions

2007-02-23
This books offers a quick, well supported by examples, review of many of the most important Oracle features covered in the Oracle Concepts and DBA Administrations manuals. The emphasis is on how to use the features effectively to solve problems in a scalable manner based on how the underlying Oracle technology works. Concise and effective are two words which describe the job Tom did.

Includes the previous book on CD!

2007-02-19
Couldn't decide whether to get this or Tom's earlier book "Expert One-on-One Oracle." Got this and was pleased to learn that the earlier book is included as a searchable PDF on the accompanying CD! How can you beat that?

My consulting experience has been that most implementers of Oracle don't know what they're doing. Read this and you'll know what you're doing; it has quick little experiments that drive home the most important points --how to make the common cases fast-- with complete explanations. I was already Oracle certified and learned some new wrinkles. You'll know why you paid for Oracle in this day of commoditized, open-source DBMS's.

Really Useful

2006-12-11
This is a great book. For the first time I can say I understand how concurrency works in Oracle. The first chapter and the ones about latches and concurrency are great. Besides, Tom has a very nice writing. He mentions some cases based on his experience as a consultant that are really interesting. Every architect/developer working with Oracle should have this book.