Priority of profile baseline patch
From: Pap <oracle.developer35_at_gmail.com>
Date: Fri, 17 Dec 2021 00:57:18 +0530
Message-ID: <CAEjw_fhCEGxhKN=UKvSpj=FKJdnS_v5uoyr_dvd=AXgnapjLyw_at_mail.gmail.com>
Hello listers, this question is not related to any specific version but a general one. As we saw its allowing us to create SQL profile(with copied outline) for same sql_id for which plan baselines already exists in both enabled and accepted state and vice versa. So wanted to understand is there a preference order or priority which oracle follows if we have all of the three i.e SQL profile, SQL baseline, SQL patch created for same SQL_id? Or it can mix up all these and results into some things unexpected plan so we should avoid these multiple options?
Date: Fri, 17 Dec 2021 00:57:18 +0530
Message-ID: <CAEjw_fhCEGxhKN=UKvSpj=FKJdnS_v5uoyr_dvd=AXgnapjLyw_at_mail.gmail.com>
Hello listers, this question is not related to any specific version but a general one. As we saw its allowing us to create SQL profile(with copied outline) for same sql_id for which plan baselines already exists in both enabled and accepted state and vice versa. So wanted to understand is there a preference order or priority which oracle follows if we have all of the three i.e SQL profile, SQL baseline, SQL patch created for same SQL_id? Or it can mix up all these and results into some things unexpected plan so we should avoid these multiple options?
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 16 2021 - 20:27:18 CET