Category Archives: Cost Based Optimizer

Why does the Oracle cbo interest me so much?

Posted on July 31, 2014 by rlockard

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

Posted on April 2, 2014 by rlockard

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

Posted on March 12, 2014 by rlockard

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