Cost-Based Oracle Fundamentals

Effective Oracle by Design (Osborne ORACLE Press Series)

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

Optimizing Oracle Performance

Databases

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

Format: Paperback
Author: Thomas Kyte
ReleaseDate: 15 September, 2005
Publisher: Apress
Rating:

Expert Oracle Database Architecture Book review
I use his web site often and appreciate all the work he does to maintain the "AskTom" site. This is the first book I have read from Tom Kyte.

The book is excellent. Tom's approach to helping you understand the concepts are displayed well with code examples. You will read a passage and then see an example to really enforce the principle. The examples support the concepts and using both together helped me out a great deal.

The chapters on architecure and indexes I found to be really helpful. The architecure chapter goes in much needed detail as so many books just glance over the different Oracle processes. What the processes are used for and how they interact with each other is well documented. The index chapter helped me understand how indexes operate at a block level and also what indexes are best for a given situation. At the end of the index chapter Tom has a section on Myth's and this section should be required reading for all DBAs and developers.

Something else I got from the book are methods for writing SQL and tuning it. The SQL that the author puts together looks so easy and natural for him to write. He is a master of SQL*Plus and that is a side benefit to reading the book. The techniques I picked up from reading Toms examples will help me just as much or more so than content of the book. This book is an excellent addition to my Oracle collection of books and I highly recommend reading it.



.

Bridges gap between DBA and Developer- Tom's Best yet
Hands down the best overall reference for becoming an Oracle DBA and developer- I like the sections on partioning, indexes, tables and development. I have all of Tom's earlier books and while he does recap some things I like the new features he mentions in 10g. I also like the included CD that has the older editions which is nice for bringing to work or on the road.

Good book
For those who already have the previous 8i edition this is one of the two parts with some 9i/10g coverage. This is a good book on ORACLE. It is a shame that the Indian edition doesn't carry the CD.