Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Shweta.

Asked: August 10, 2020 - 2:14 pm UTC

Last updated: August 10, 2020 - 2:39 pm UTC

Version: 11204

Viewed 1000+ times

You Asked

Hi,

We are migrating our 7TB oracle database to another server . It would consist of upgrade from 11g tp 12c .

Could you suggest of anyways where we can make sure that all the queries in the target database picks the same plan as before?

Thanks.

and Chris said...

You can create SQL plan baselines - part of SQL plan management (SPM) - to lock queries to specific plans.

We recommend doing this to help minimize risk during upgrades and migrations, read more at:

https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-sql-plan-mgmt-19c-5324207.pdf

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.