Plan changed After creating profile

  • From: Krishnaprasad Yadav <chrishna0007@xxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Sep 2021 00:44:57 +0530

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2021