Home -> Mailing Lists -> Oracle-L -> Plan changed After creating profile

Plan changed After creating profile

From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Thu, 30 Sep 2021 00:44:57 +0530
Message-ID: <CAO8FHeXueVuGp2wd_e8moPG49_v85yeGp9Y2fffKNsxRAgkMyA_at_mail.gmail.com> 





Hi All ,



We have created sql profile on select statement ,but we see plan is
changed  and worst plan  is used in execution rather than sticking to plan
for which fixed it with profile .



Is any way to avoid it or how can we stick permanently so that it can be
fixed with permanent plan .



Regards,


Krishna


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


Received on Wed Sep 29 2021 - 21:14:57 CEST












Original text of this message