Re: Best course to understand why a bad plan is chosen by optimizer

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 15 Sep 2019 17:28:38 +0000
Message-ID: <CWXP265MB1750D75E039A85D08CEBD128A58D0_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>

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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of kunwar singh <krishsingh.111_at_gmail.com> 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
--

http://www.freelists.org/webpage/oracle-l Received on Sun Sep 15 2019 - 19:28:38 CEST