“It is all about understanding.”

These words belong to Tom Kyte, written on the preface of Jonathan Lewis‘s latest book Cost Based Fundamentals of Oracle. If you are paying your bills as an Oracle database developer or dba without doubt it is of course all about understanding the optimizer, why it does what it does as Kyte mentions.

Last year we were very excited about this book and immediately organized a weekend summit :) to study as a group. The members were our internship program students and the weekend was a real success. We prepared an hour presentation for each chapter, group discussion was very effective and educative.

So this year we planned to repeat this event with the support of the new internees of last summer. Another good news is my company, Turkcell Teknoloji, will be our sponsor this year, for the place and the foods :)

Opening Preface Never say “never again” – H.Tonguç Yılmaz
Chapter 1 What do you mean by cost? – Merve Olamlı
Chapter 2 Tablescans – Merve Olamlı
Chapter 3 Single table selectivity – Ersin Ünkar
Chapter 4 Simple B-tree access – Özay Akdora
Chapter 5 The Clustering Factor – Engin Zorlu
Chapter 6 Selectivity Issues – Mert İnan
Chapter 7 Histograms – Özgür Macit
Chapter 8 Bitmap Indexes – Aykut Öztürk
Chapter 9 Query Transformation – Baran İpek
Chapter 10 Join Cardinality – Engin Kurtoğlu
Chapter 11 Nested Loops – Övünç Bozcan
Chapter 12 Hash Joins – Ertük Diriksoy
Chapter 13 Sorting and Merge Joins – Ertürk Diriksoy
Chapter 14 The 10053 trace file – Hüsnü Şensoy
Appendix A Upgrade Headaches – Hüsnü Şensoy
Appendix B Optimizer Parameters – Hüsnü Şensoy
Additional topic : Oracle 11g OCI New Features – Ogün Heper

Here are two additional resources to the book I may advice;
Jonathan Lewis’s comments on each chapter
Wolfgang Breitling’s presentations and articles

Thanks to Jonathan Lewis for his efforts and making this book possible, it is a great value to the Oracle community and we are waiting for the triology to continue :)

Also as we have Jonathan’s permission to share the presentations we prepare for the weekend studies, I will be updating this post with the material available ~10 days later, see you than.

1 Comment

Leave a Comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s