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