此前我曾经提到过,Jonathan Lewis 可能在写一本有关 CBO 的新书.最近从他的站点上看到,他的新书 Cost Based Oracle – Volume 1 就要出版了.
Volume 1 of Cost Based Oracle covers the fundamentals of Oracle’s optimizer. The topic is just too big for me to be able to tell you all you need to know about every possible circumstance and every version – but this book gets you going with 90% of what you need to know for 90% of the SQL you will write. Not only does it explain the models used, the calculations, and the things that can happen at run-time; it gives you scripts so that you can reproduce the test-cases on your own systems and see the changes that appear as you change parameter values, enable or disable features, add hints, or upgrade your version of Oracle.
Jonathan 的写作态度一向很严谨.相对来说,不算很高产的作家.但是他在 dbazine 上的每一篇文篇章都会引起很大的关注.他的代表作品当然是 Practical Oracle8i — Designing Efficient Databases .虽然有个 8i 的题目,不过这本书即使是在10g 快开始风行的今天仍然又非常大的参考价值.
不知道什么具体原因, Addison-Wesley 放弃了和 Jonathan的 再次合作,于是乎 Apress 就当仁不让了.
After a long and irritating delay, Addison-Wesley decided that they didn’t want to take up their option on my second book, so Apress have jumped on it and are up and running with it. Expect it on the shelves in November 2005 – but if you are coming to the UKOUG annual conference, there should be some early copies on the Oak Table/Apress stand on 31st October.
Cost Based Oracle 将由这本书的技术编辑是 Wolfgang Breitling 与 Christian Antognini.Wolfgang Breitling 也是一位 CBO 方面的专家.他的一些论文堪称经典.如:A Look under the Hood of CBO: The 10053 Event, 在网上关于 CBO 的文章中,这是引用率最高的一篇.
Technorati Tags: Cost+Based+Oracle, CBO, book, Jonathan+Lewis
个人感觉,10g开始,oracle留给dba的发挥的空间越来越小,高性能sql可能将来是唯一可参与的部分了
Cost-Based Oracle Fundamentals 与 Apress 及其他
最近公司的 DBA 团队购买的 Cost-Based Oracle Fundamentals 到货,居然还没被借走,趁早借回来一睹为快。
想必很多人对以前国内大规模引…