Advertisement

Event 10053 and the Cost Based Optimizer

  • Norbert Debes

Abstract

There is no better way to comprehend decisions and cost calculations of the cost based optimizer (CBO) than to read an optimizer trace file generated with the undocumented event 10053. Oracle Support will usually request such a trace file if you intend to file a technical assistance request against the optimizer in situations where it fails to find an execution plan that yields an acceptable response time.

Keywords

Stimated Ather Larg 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations