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

Thanks Jonathan , Mark for very valuable information! I will look into them

On Sun, Sep 15, 2019 at 1:29 PM Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:

> 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
>
>
> --
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l