Tuesday, May 08, 2012

SQL Plan Baselines: Migration from one Instance to Another.

  1. Create staging table. it needs to be created only once. Script to create staging table is

  2. Transfer baselines to staging table. Script to transfer sql plan baselines to staging table is

  3. Export staging table

  4. Copy file to desired instance and then import it

  5. Load sql plan baselines from staging table. Script to load sql plan baselines is

  6. Record from Staging table can be deleted so that only new sql plan baselines can be migrated or you may unpack only selected sql plan baselines using function dbms_spm.unpack_stgtab_baseline.

1 comment: