Category Archives: Cost Based Optimizer

Why does the Oracle cbo interest me so much?

There is a short answer and a very long answer to this.  I will try and keep the answer somewhere in the middle of short and long. The first assumption we must accept and from my observations over the past … Continue reading

Posted in Cost Based Optimizer, Database Stuff | Tagged , | Leave a comment

Oracle 10053 trace viewer

There are two trace files that I use when tuning.  Cary Millsap @CaryMillsap and Method-R @MethodR have a great tool for analyzing the 10046 trace file. There is the profiler and my personal favorite mrskew http://method-r.com/store . But the 10053 … Continue reading

Posted in Cost Based Optimizer, Database Stuff | Tagged | Leave a comment

Exploring the CBO

Lets start with a simple experiment on what the CBO can do with query optimization. We are going to build on the structure as we go to see if we can help out the CBO with more information. Test 1) … Continue reading

Posted in Cost Based Optimizer, Database Stuff | Leave a comment