Re: Best course to understand why a bad plan is chosen by optimizer
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,
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.
--
Silly question :)
Cheers,
Kunwar
http://www.freelists.org/webpage/oracle-l
Received on Sun Sep 15 2019 - 19:28:38 CEST