Spm used but plan is different
From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Wed, 22 May 2019 13:22:35 -0400
Message-ID: <CAJSrDUofe04UcH+cBVXshtu=vrGF9jqEVg-JQM-sLov7q+ToOg_at_mail.gmail.com>
hi listers
We are migrating from 11g to 12.2
And as part of performance testing we found that few plans regressed and I tried to copy the plan from 11g using spm . Spm is getting used but plans are different and run times are bad still. Same is the case by using ofe of 11.2.0.4 . Don’t see any helpful notes on mos for the steps I should take to resolve why plans are not same . And there is no single common difference in the plans which is causing this issue .
Date: Wed, 22 May 2019 13:22:35 -0400
Message-ID: <CAJSrDUofe04UcH+cBVXshtu=vrGF9jqEVg-JQM-sLov7q+ToOg_at_mail.gmail.com>
hi listers
We are migrating from 11g to 12.2
And as part of performance testing we found that few plans regressed and I tried to copy the plan from 11g using spm . Spm is getting used but plans are different and run times are bad still. Same is the case by using ofe of 11.2.0.4 . Don’t see any helpful notes on mos for the steps I should take to resolve why plans are not same . And there is no single common difference in the plans which is causing this issue .
So wanted to know what your methodology in finding why spm is not using the same plan . Same is the case with sql profile and it getting used
my question is more in general and not query specific .
--
Cheers,
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 22 2019 - 19:22:35 CEST