I presented my latest white paper at the 2009 Rocky Mountain Oracle Users Group Training Days Conference yesterday. Called “Using the 10053 Event To Understand Index Behavior”, I discussed how the 10053 event dumps out the statistics and calculations used by the Cost-Based Optimizer (CBO) to develop execution plans. We can use the resulting trace file to gauge what effect specific initialization parameters and optimizer statistics have on the CBO’s decisions. We can even diagnose those decisions when they result in suboptimal plans.
Follow these links for copies of the presentation and paper.
