Home -> Mailing Lists -> Oracle-L -> Plan Baseline

Plan Baseline

From: manikandan <pvmanikandan_at_gmail.com>
Date: Mon, 9 Aug 2021 02:22:01 -0400
Message-ID: <CAB6JwgiMkFpb1msknB-sf5-Kcs4LpaSBC5caEoO8RY9RRnufFA_at_mail.gmail.com> 





Hi,



We have implemented SPB for one query with a good plan. Post implementation
CBO was able to use the baseline without issue. We went for DB bounce after
that due to one-off patch maintenance and after the DB bounce CBO is unable
to use the BASELINE anymore and has created a new plan. We have tried
flushing the cursor multiple time but of no use. How we can force the SQL
to use the baseline? What would be the cause of query not being used sql
plan baseline post DB bounce?. Database version is 12.1.0.2 + RAC 5 nodes +
AIX.


Thanks,


Mani


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


Received on Mon Aug 09 2021 - 08:22:01 CEST












Original text of this message