Using the 10053 Event to Understand Index Behavior

Abstract:

Using or ignoring an index is one of the most important decisions Oracle's Cost Based Optimizer (CBO) can make. The 10053 event traces how the CBO makes this decision and provides valuable insight into this process. Using the 10053 event, this paper demonstrates how changes to critical initialization parameters affect whether index operations get included in execution plans

Presention (.pdf) and white paper (.pdf) for Rocky Mountain Oracle Users Group (RMOUG) 2009 Training Days Conference

Tuning Knife Consulting

Using the 10053 Event to Understand Index Behavior

Comments