Export of a Capture AWR Exports The Entire Contents of WRH$_SQL_PLAN When the Source capture Database is Version 10.2.0.4.0
(Doc ID 2210246.1)
Last updated on NOVEMBER 27, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
- Exporting the Capture AWR on 10.2.0.4 results in the entire table for WRH$_SQL_PLAN; being exported instead of the portion of WRH$_SQL_PLAN; that is related to the actual AWR Capture snapshot range during the Capture
- Applying the Mandatory Capture side <Patch 10239989> does not impact the behavior
- The export log will show a large amount of data being exported for the WRH$_SQL_PLAN table.
- Importing the Capture AWR into the target replay test database may take hours due to the following SQL populating the WRH$_SQL_PLAN table:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document