Hey CP,
yes, there are several great sources for this.
Understanding the CBO principles:
---------
* Cost-Based Oracle Fundamentals by Jonathan Lewis:
https://www.apress.com/de/book/9781590596364
* Some of the newer CBO behavior by Alberto Dell'Era:
http://www.adellera.it/static_html/investigations/
Reading CBO traces:
---------
* Chasing the optimizer by Mauro Pagano;:
https://de.slideshare.net/MauroPagano3/chasing-the-optimizer-71564184
I guess the latter is the one you are looking for as it explains an analytical
approach to digest any CBO trace file, decomposing it into smaller pieces and
make it easy to analyze.
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
Cee Pee <carlospena999@xxxxxxxxx> hat am 19. Juli 2018 um 22:49 geschrieben:--
Nice thread, we get same kind of problems too. Is there a book or paper on
how to read the 10053 trace file, like "basics of 10053"?
Reading Tim's response, I think it is a good time someone wrote a book on
that topic.
CP