Re: SQL performance in prod
Date: Fri, 20 Jul 2018 10:09:51 +0200 (CEST)
Message-ID: <435617319.6057.1532074191906_at_ox.hosteurope.de>
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: _at_OracleSK
> Cee Pee <carlospena999_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 20 2018 - 10:09:51 CEST