Hello, Recently we upgraded from 10g to 11g , some of the queries take long time to execute and complete. Around double the time from 10g env.
Our queries were using DISTINCT and joining couple of views and tables then i read about parameter _optimizer_extend_jppd_view_types, after changing alter session set "_optimizer_extend_jppd_view_types"=false and testing in session query time comes down by 30% but explain plan remains same as that of 11g.
Open question is doing alter session set "_optimizer_extend_jppd_view_types"=false should also change query plan ?
If query plan is not changed can it be safe to assume parameter _optimizer_extend_jppd_view_types has not effect on query ?
Same query has different plan in 10g & 11g.