Thanks for the question, Gernot.
Asked: April 22, 2025 - 1:03 pm UTC
Last updated: April 24, 2025 - 4:18 pm UTC
Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.26.0.0.0
Viewed 100+ times
You Asked
Hello,
I have multiple baselines and after migrating the application many of them got not reproducible.
The reason was renaming of some indexes during the migration.
I have renamed those indexes back to the original name.
My question is how I get Oracle to set those baseline back to reproduced = YES.
Non of the DBMS_SPM routines is able to do that.
Thanks
and Chris said...
I reached out to Nigel Bayliss, PM for SPM, about this. There was a bug related to this (30220932), which may explain the behaviour you're seeing.
With the fix, it should work like this:
* If a plan fails to reproduce, the reproduced flag is updated immediately (that’s what the bug fix did).
* If a plan reproduces when it previously failed, the update is deferred. The flag update piggybacks on the update of LAST_EXECUTED, which is about once a week.
So: check that you have the fix for 30220932 included in your system. If it is, wait check for the update of LAST_EXECUTED. If this is still a problem, I suggest reaching out to support.