books:

	• Expert One-on-One Oracle Thomas Kyte Apress, 2003 - 1297 pages average customer review:based on 77 reviews view larger image
	for more information click here

highly recommended

This is the first book I have seen that looks clearly and concisely at effective Oracle development. Tom's discussion for example of the use of bind variables is both entertaining and informative. Similarly the comparative discussion of locking mechanisms and the impact that differing implemetations of this have on effective coding is essential reading for all of those developers tempted down the 'one approach suits all databases' road. All of this detailed technical knowledge is explained and illustrated with examples that you can easily run yourself to verify the impact that effective coding could have on your own applications.

Just as Jonathan Lewis' book should really be made available to all the DBAs in your organisation, so too should this book be on the developers bookshelf (or better yet desks).

for more information click here

Foremost Resource of Advice and "Best Practices"

Having never worked with Oracle before, I picked up TKyte's book as a source of advice for designing an Payroll/Commissions Oracle database. I went to the book to ask a series of questions:
1) Which should be used MTS or Dedicated servers?
Kyte's advice: "Unless your system is overloaded, or you need to use MTS for a specific feature, a dedicated server will probrably serve you best."
2) What type of locking strategy should I use?
Kyte's advice: "In my experience, pessimist locking works very well in Oracle and has many advantages..."
Kyte lays a introductory foundation by describing (in detail and with diagrams) the internal architecture of Oracle. His opinions and advice are given with plenty of evidential support. His coverage of topics is thorough and exhaustive: He spends time discussing each option a developer has in Oracle 8i, the gives his recommendations for the usage and pros/cons of each. In this manner he doesn't discriminate against "impractical" features by excluding them. This book not only details what a developer can do with Oracle but what the developer should do. These recommendations are based on proofs that TKyte walks the reader through. As a brand new (straight out of college) programmer who does not have anyone else in the office (and no one to call) to consult on Oracle, this book has been a lifesaver, putting Oracle expertise in my hands.

for more information click here

Buy this book

This is by far the best ORACLE book ever written. There is no excuse for any DBA/Developer not to own it.

for more information click here

The best technical book ever!

This book is fun to read! If there were a Pulitzer Prize for technical writing, it would go to Tom. I've read his advice for years. Not only does he give the best solutions, he is probably the kindest person on the web. There is no question too dumb. He consistently shows an uncommonly high amount of respect for the people he helps.

A word of caution, though. It's really geared more toward the architect or DBA than it is the application developer.

Also, this is an advanced book that assumes some prior experience with Oracle. Not a good book for beginners.

for more information click here

reviews: 1, 2, 3, 4, 5, 6, 7, 8, 9, page 10, 11, 12, 13, 14, 15, 16

hot

or

not?

What's your opinion?     Write a review and share your thoughts!

recommendations

Books that need to be on an Oracle DBA's shelf
Oracle Database Performance Tuning List
Oracle books for the desert island
Oracle Certication Program
Be an Oracle DBA