| help | account  


Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
View Larger Image
Thomas Kyte
Apress, Paperback, Bk&CD edition, Published September 2005, 768 pages, ISBN 1590595300
List Price: $49.99
Our Price: $30.50
You Save: $19.49 (39% Off)


FREE Shipping on Orders over $40!*
Availability: In-Stock
Read an excerpt:
Chapter 2: Architecture Overview

     

Download a detailed table of contents.

Excerpt provided courtesy of Apress. Copyright © Apress. Written permission from the publisher is required for any use of this material.

Customer Reviews: 2     Average Customer Rating:

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:

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

 

About the Author

Thomas Kyte is the vice president of the Core Technologies Group at Oracle Corporation and has been with the company since version 7.0.9 was released in 1993. Kyte, however, has been working with Oracle since version 5.1.5c.

At Oracle, Kyte works with the Oracle database, and more specifically, he helps clients who are using the Oracle database, and works directly with them specifying and building their systems or rebuilding and tuning them. Prior to working at Oracle, Kyte was a systems integrator who built large-scale, heterogeneous databases and applications for military and government clients.

Tom Kyte is the same "Ask Tom" whose column appears in Oracle Magazine, where he answers questions about the Oracle database and tools that developers and DBAs struggle with every day.


Customer Reviews

Customer Reviews: 2     Average Customer Rating:

Apr 5, 2006     Ben from USA
A Real Oracle Guru
I bought two of Tom's books and have read a couple of chapters of each and already love them! First I learned from Tom that I can use a logon script to set up a unique SQL*Plus prompt. And you thought that would be so trivial but IT IS NOT. I have seen the DBA accidentally done things in the production and caused problems right away because he thought he was doing them in the dev database! All because he does not have a unique SQL*Plus prompt that Tom teaches! I love the way Tom proves almost everything by examples. Don't believe me? Run the example yourself. I have been working with Oracle for some years now but I just found out that there are so many things that Tom can teach me. Can't wait for the next version of the Expert Oracle One On One. The other thing that I love Tom's books is that he does not trash the competitors' databases, and instead he says it just so happens that each database works differerntly and sometimes so fundamentally differently that porting from one database to another is a huge task if not possible. He recommends that we should use the database specific features to our advantage because that is what we have paid for.

Mar 15, 2006     Greg Smith (greg@smithcon.com) from Portland, OR
There is only one way to write a good quality Oracle app ...
... know EVERYTHING in this book before you start!!!

Seriously, there are so many Oracle programming misconceptions and false truths about floating around in IT departments today, it makes my head spin.

These long-obsolete (or, in many cases, completely unfounded) beliefs inevitably lead to poorly performing system designs.

Oracle is the most powerful database tool on the planet, and it has an extremely elegant model for handling extreme volumes of data, huge concurrent transaction loads (without time-stopping contention problems), and amazing scalability, all without the need for any special programming.

All you have to do is read this book to exorcise all of the old and misguided database design and programming advice you have likely absorbed over the years.

Not only will your systems perform better, but your code will be simpler and more elegant, and you will likely save your IT department 100-1000x the price of this book in lessened hardware needs alone!

Since you haven't read the book yet, I'll start you off on two things you will learn:

1. NO, you probably don't need another index!

2. The cache hit ratio is that LAST thing you need to worry about!



Forgot your password?
FAQs
Shipping Options
Returns
Your Orders
Your Account