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)
| | | 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: - Expert Oracle Database 10g Administration; Sam R. Alapati, $36.95, 38% Off!
- Pro Oracle Database 10g RAC on Linux: Installation, Administration and Performance; Julian Dyke, et al, $42.50, 39% Off!
- Cost-Based Oracle Fundamentals; Jonathan Lewis, $30.50, 39% Off!
- Effective Oracle by Design; Thomas Kyte, $35.95, 40% Off!
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!
|