Best course to understand why a bad plan is chosen by optimizer
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Thu, 12 Sep 2019 21:43:09 -0400
Message-ID: <CAJSrDUroMQbuSjzFC4A70Qx4sX=R2VDqfUarHOBpkeWWyxDU=A_at_mail.gmail.com>
Hi Listers,
Silly question :)
Cheers,
Kunwar
Date: Thu, 12 Sep 2019 21:43:09 -0400
Message-ID: <CAJSrDUroMQbuSjzFC4A70Qx4sX=R2VDqfUarHOBpkeWWyxDU=A_at_mail.gmail.com>
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 Fri Sep 13 2019 - 03:43:09 CEST