I used to run a day-long course that would probably have met your requirements.
I don't run it any more, but Richard Foote (https://twitter.com/richardfoote ;)
looks like the next best thing.
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of kunwar singh <krishsingh.111@xxxxxxxxx>
Sent: 13 September 2019 02:43
To: ORACLE-L
Subject: Best course to understand why a bad plan is chosen by optimizer
Hi Listers,
Silly question :)
Is there any Oracle guru who give course on this specific topic and goes much
in depth.
Not looking for course on sql tuning. I am able to tune the query in most
cases, it is the optimizer decisions for many queries in a new version
upgrade(11g to 12.1.0.2).. which are giving me some headaches as many
applications we support generate queries dynamically and statistics
optimization is the farthest i am able to go to get good plans.
Cannot use SPM options due to dynamic nature of sqls generation.
--
Cheers,
Kunwar
--
//www.freelists.org/webpage/oracle-l