- Paperback: 768 pages
- Publisher: Apress (December 13, 2005)
- Language: English
- ISBN-10: 1590595300
- ISBN-13: 978-1590595305
- Product Dimensions: 7 x 1.7 x 9.2 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
- Average Customer Review: 33 customer reviews
- Amazon Best Sellers Rank: #2,302,654 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
What other items do customers buy after viewing this item?
About the Author
Thomas Kyte is 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 database administrators struggle with every day.
Browse award-winning titles. See more
Top customer reviews
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.
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.
1. It is not a manual for an Oracle administrator. For example it does not contain anything about Oracle installation, troubleshooting, backing up or restoring a database.
2. It is not a SQL or PL/SQL reference, neither it is a introduction to databases. You have to know a significant deal about databases already for the book to make effect.
3. It is not an optimization guide. You will not find execution plans and configuration parameters here.
What is it then ?
It is an extensive coverage of Oracle internals - its files, memory structures, processes, undo/redo, tables, indexes and data types. Plus it explains Oracle's approach to transactions, locking and concurrency. On top of it, a couple of chapters offer you a view to partitioning and parallel execution being another very specific tools.
The book introduces you the Oracle ultimate goal of building highly concurrent database applications and then walks you through its internal details to show how to achieve it in the applications you build.
The book strikes the right balance so as not to go deep into unnecessary bit flags and names of undocumented variables, but clearly explain the architecture of the engine. The architecture (also mentioned in the title) is the "whiteboard" kind of architecture - the one you can sketch on a whiteboard with a couple of boxes and a few arrows, which is just right in this case.
The target audience for this book is anyone who develops applications with Oracle as the database back end. It is a book for professional Oracle developers who need to know how to get things done in the database. The practical nature of the book means that many sections should also be very interesting to the DBA.
The author is undoubtedly an expert, who has been working for Oracle for 15 years, with Oracle for even longer and has been consulting for God knows how many years. He also sticks to an honest, pragmatical and straightforward approach - there is not a single "enter Oracle, hold your breath" word.
The inspiration for the material contained in this book comes from my experiences developing Oracle software, and from working with fellow Oracle developers and helping them build reliable and robust applications based on the Oracle database. The book is basically a reflection of what I do every day and of the issues I see people encountering each and every day.
Like the other good books out there, it just gives you something to think about. Avoiding rules of thumb,
This is one of the main reasons why rules of thumb do not work on real-world systems: what works for you might not work for others in similar but different conditions.
it gives you the invaluable knowledge you could apply to your work. It is up to you to apply it afterwards.
Written very clearly, very easy to understand, nice trimmed examples, no screenshots. Highly recommended reading.
Most recent customer reviews
I suggest Oracle Developer & DBA read this book.Read more
this book is the base book for every programmer in oracle, which explains the main architecture principles of this DB system by intelligible language of Tom Kyte, the...Read more
Tom is an author full of humor with a versatile approach to performance.Read more