My Oracle Support Banner

How to Use Database Replay Feature to Help With The Upgrade From to 11g (Doc ID 748895.1)

Last updated on FEBRUARY 24, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


The purpose behind creating this article is to give a detailed information about using the Database Replay feature before upgrading from to 11g, supported by a life example.

Before making changes, such as hardware or software upgrades, companies typically conduct extensive testing to validate the changes. However, when the change is made on the production system, unexpected problems are often encountered because the testing was not performed with a workload that was a good representation of the production environment. Tools are available in the market to construct "synthetic workloads" involving multiple users. However, they are not able to adequately simulate the complexities of a real-world workload, such as interactions between concurrent activities and unpredictability of the workload profile.

DB replay does this by capturing a workload on the production system with negligible performance overhead ( My observation is 2-5% more CPU usage ) and replaying it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This makes possible complete assessment of the impact of the change including undesired results; new contentions points or performance regressions. Extensive analysis and reporting ( AWR , ADDM report and DB replay report) is provided to help identify any potential problems, such as new errors encountered and performance divergences. Thus using Database Replay, businesses can incur much lower costs and yet have a high degree of confidence in the overall success of the system change and significantly reduce production deployment.

The ability to replay the workload, however, has been introduced in Oracle Database 11g (11.1). This has been done so that when you upgrade from Oracle Database release to 11.1 or 11.2, you can use the Database Replay feature to help with the upgrade.

Actually, the Capture feature has started to be included starting from (DBMS_WORKLOAD_CAPTURE) but the Database Replay complete functionality started in and up. Thus you can use the capture process to capture the workload in and then on a test environment replay the captured workload into 11g database before doing the upgrade.

The workload that has been captured on Oracle Database release and higher can also be replayed on Oracle Database 11g release. So it simply mean NEW patch set will support capture processes.

The database capture functionality was introduced with However, patches are available for some earlier versions.
Please refer to:
Using Real Application Testing Functionality in Earlier Releases (Doc ID 560977.1)

Note also that Database Capture and Replay is part of the Real Application Testing (RAT) option which needs a separate license.


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
 Steps for Database Replay

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.