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
Last updated on MAY 10, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms