Other Sellers on Amazon
+ $3.99 shipping
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
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.
Customers who viewed this item also viewed
About the Author
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.
- Item Weight : 2.8 pounds
- Paperback : 768 pages
- ISBN-10 : 1590595300
- ISBN-13 : 978-1590595305
- Dimensions : 7 x 1.74 x 9.25 inches
- Publisher : Apress (December 13, 2005)
- Language: : English
- Best Sellers Rank: #4,400,274 in Books (See Top 100 in Books)
- Customer Reviews:
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
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.
Top reviews from other countries
This book however is a lot more suitable for DBA's, with some sections that are not available for application developers.
If you are a DBA, I would definitely recommend this book as Thomas Kyle definitely knows his stuff. If you are an application developer working with PL/SQL, then there are more suitable books for us.
Still an excellent book, but just not for me...