SQL Performance (MOSC)

MOSC Banner

Baseline reproduced flag

edited Feb 2, 2015 9:50AM in SQL Performance (MOSC) 4 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center