Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

January 31, 2008

Eddie Awad’s http://oraclecommunity.net – I like twitter, here is a small demo :)

Filed under: Oracle Other — H.Tonguç Yılmaz @ 9:01 pm
oraclebase oraclebase @eddieawad I’ve blogged about the site and I’ve put some links from my blog and blog aggregator. That must be worth a least one member. :)
oraclebase oraclebase @TongucY I’m going to quit my job so I can concentrate on social networking. :)
H.Tonguc YILMAZ TongucY but it is getting so hard; follow blogs, otn oracle-l and local forums, wiki, mix, twitter, facebook, technorati / need one to rule them all
oraclebase oraclebase @TongucY (@eddieawad ) Mix is more LinkedIn. OracleCommunity is more FaceBook. :)
Dan Norris dannorris I’ll be soooo happy when the elections are over and media goes back to providing (mostly) useful information instead of dirt on candidates.
Eddie Awad eddieawad @oraclebase 8 is a very lucky number, at least for the Chinese people.
Eddie Awad eddieawad @TongucY Sure not. mix and oraclecommunity.net are different even though they share a few common things.
oraclebase oraclebase I’m member number 8 in the Oracle Community…
H.Tonguc YILMAZ TongucY @eddieawad thank you Eddie, so this is not an alternative for mix.oracle.com right? :)
Eddie Awad eddieawad @TongucY have fun, meet new people, anything you and the community want it to be.
H.Tonguc YILMAZ TongucY my first impressions, http://oraclecommunity.net is really awesome! but what will be its mission Eddie? :)
Eddie Awad eddieawad http://oraclecommunity.net is here. DM me your email or go to http://awads.net/wp/contact to request an invite to join.
Advertisements

“It is all about understanding.”

Filed under: Oracle Other,Oracle Performance — H.Tonguç Yılmaz @ 6:35 pm

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.

Blog at WordPress.com.