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 email address or mobile phone number.
Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions Paperback – July 25, 2010
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
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.
Top Customer Reviews
The author of this book is a Vice President at Oracle Corporation, and is well known for his [...] website, articles in Oracle's magazine, forum/Usenet postings, and presentations. The author recently revised the Oracle Concepts Guide, which is part of the Oracle Database 11.2 documentation library. Slightly off topic: It might be notable that a book written by a VP at Oracle Corporation is not published by Oracle Press. Oracle Press is a marketing label used by McGraw Hill to market its line of Oracle books - the books are not formally written by Oracle Corporation nor are they formally tech edited by Oracle Corporation, although some employees of Oracle Corporation have used McGraw Hill as a publishing company. At least for me, for several years the "Officially Authorized Oracle Press" logo on books published by McGraw Hill seemed to be endorsement of the books by Oracle Corporation, but that is not the case, as was clarified by one of the threads on the AskTom site.
The book contents are very well organized, allowing the reader to continually build on previously introduced concepts.Read more ›
Like the first edition Tom spends careful time upfront with a whole long section just on setting up your "environment". Now for those folks who don't use the command line often, you had best dig out your guides, howtos and documentation, and bring yourself up to speed.
The book is laid out with endless examples of how to do things illustrated using sql*plus the Oracle shell. As he reminds us, this is far and away the best way to learn about the inner workings of the database, and his clear and step-by-step examples really drive that home.
As he explains, you'll find that the chapters are mostly self-contained, so you can read them in different order, while still making sense of the whole. Chapter 1 discusses database applications overall, and in particular how to best utilize the Oracle technology and horsepower you've licensed.
Chapter 2 covers the overall architecture of an oracle database outlining how instances are different than a database, and how RAC fits into the picture.
There may be some area you are weaker in, such as memory structures - the PGA, SGA and UGA. So jump straight to chapter 4 for that. Want to know more about locks and latches, chapter 6 will cover that material.
When you get to chapter 10 on tables, you will realize just how much the database has evolved over the years. How many different types of tables are there? There are heap tables, index organized tables, index clustered tables, hash clustered tables, nested tables, temp tables, and object tables. Wow, that's quite a long list.Read more ›
Tom covers the fundamental concepts and deep insights using simple conversational language, in the style of his "Ask Tom" columns. The book also provides many useful examples, codes and tips on resolving real world issues. An example of bind variables tells how much hard parsing utilizes resources (cpu/latches etc) and I was also impressed that Tom always finds ways to measure the usage. I had some blurred concepts about LOBs and parallel query/DML/DDL. This book helped me to clarify them. The book also covers some 11g new features. We need to keep track of what Oracle has already done to avoid reinventing the wheel.
I also enjoyed the following sections and found them useful and interesting:
- How (and How Not) to Develop Database Applications
- Bad Transaction Habits
- Frequently Asked Questions and Myths About Indexes
To develop a successful Oracle application, we should understand the database inside out. What I like the most about this book is that it not only tells you "what" but also "how"; explains not only "when" and "why" but also "when not" and "why not". That's the main reason I read Tom's book and visit his site - to get the "why" behind the methods. It's uncomfortable to implement something without knowing why.
You don't have to read this book from cover to cover - although it would be a good idea to do so.Read more ›
Most Recent Customer Reviews
I had always wanted to buy this book. There used to be a low price Indian edition that cost Rs. 700 for the hard copy. Read morePublished 22 months ago by Sathya Narayanan
Can't recommend this highly enough!
I learned so much about Oracle from this book and as he recommends - the oracle concepts manual
He doesn't just teach you about... Read more
I have met and talked to Tom several times. He is clearly the most gifted in translating his knowledge using examples that are very clear, easy to understand and to the point. Read morePublished on January 5, 2014 by Subramanyam Jayaraman
Nicely compiled and great examples to clear all clouds in any DBA's mind about database architecture. And, written by most efficient Oracle auro on the earth.Published on June 25, 2013 by Rakesh
If you ever wants to learn and understood the Data Base, this is the only book you need.
All theory can be supported and be proven by the code. Read more
I don't purchase many technical books. I have worked with Oracle RDBMS for more than 20 years, yet I bought only 2 books in the last 10 years. Read morePublished on March 16, 2013 by kc
A very valuable resource for any developer involved with database related projects. I'm sure this is the best oracle book I ever read.Published on October 24, 2012 by Cliente Amazon