How to Transfer Stored Outlines from One Database to Another (9i and above)
(Doc ID 728647.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 9.0.1 to 11.2] Oracle Database - Standard Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2] Information in this document applies to any platform.
This document shows you how to export Stored Outlines from one database and import them on another in Oracle9i and above.
For Oracle8i please use:
<Note:102311.1> How to Transfer Stored Outlines from One Database to Another (8i)
A typical usage scenario is when queries are getting a sub-optimal execution plan in a production database PROD, but are performing well in a similarly configured test database QA. Here it is possible to force each query on PROD to use the same execution plan as on QA via a Stored Outline. The steps are:
create Stored Outlines for the queries on QA
export the Stored Outlines using the EXP utility
transfer the dumpfile to the production system
import the Stored Outlines on PROD using the IMP utility
enable them for use thus allowing the queries on PROD to use the same plan as on QA
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!