Baseline reproduced flag
Hi everyone,
I have 2 database both on 11.2.0.3, let's call them target and source.
I export a baseline from source database to target database. I pack it in a staging table on source. EXP, then IMP on target and then proceed to unpack the baseline. Everything works fine.
But once I run the forms calling the SQL on which I want to baseline, the reproduced flag of the baseline changes from YES to NO.
Oracle then creates a new baseline and go on using this one. The problem is it's not the optimal plan. On source database the query takes 2 seconds; where it takes more than 30 seconds on target. I can see the difference in the plan.