Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions (英語) ペーパーバック – 2010/10/1
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.
This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.
Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.
- Fully revised to cover Oracle Database 11g
- Proof-by-example approach: Let the evidence be your guide
- Dives deeply into Oracle Database’s most powerful features
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.
I been interviewing DBAs for my performance team and was surprised to realize that most of them can not explain concepts from this book. This is must read for anyone dealing with the Oracle database tuning. Add 'Oracle Database Performance Tuning Guide' from Oracle to this mix and you know enough to do some serious work.
We ordered several of those books for company use but I also keep personal copy on the nightstand.
I do have a single caveat for this edition that cost it a star: there are no notes that point out the changes between this and the previous edition of this title. The changes are of course centered on Oracle 11g new features, so you can find changes if you know Oracle 11g's new features are, but I find myself a bit disappointed that I couldn't jump to the new/changed sections straight away, and that no notes or tips are in place once you are in a changed section about what text specifically is new. The text itself does mention which Oracle version specific features were introduced in, so you can pick out the new 11g changes from the main body of text -- still, I would have preferred side notes or some kind of highlighting to make this info easier to find.
If you don't already have the first edition of this book, buy and read this edition cover-to-cover; my caveat does not apply to you in any way. If you possess and have already read the first edition, buy this before you upgrade to 11g and familiarize yourself with the real operational details of 11g's new and modified features. I plan on reading the new edition cover-to-cover anyway, as the material is good enough to rehash and I imagine I will pick up things I overlooked or have forgotten since my full read-through of the first edition.
I learned so much about Oracle from this book and as he recommends - the oracle concepts manual
He doesn't just teach you about Oracle, he encourages you to think for yourself and to prove your theories about the causes of problems - and he gives you the code to do it.
Catch his website 'ask tom'
Some of the issues he explains like the 'snapshot too old' problem, likely caused by commiting inside a cursor loop, have been the subject of questions from site visitors for twelve years or more. Shame they didn't just read the book!
I wish Amazon has the Kindle version of this book so I can have it on my Kindle!