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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). Event 10053 and the Cost Based Optimizer. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_7
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books