My Oracle Support Banner

Real Application Testing: Consolidated Database Replay Feature (Doc ID 1453789.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
Applies to:
Oracle Server - Enterprise Edition - Version: and above
Information in this document applies to any platform.


The Real Application Testing database option was introduced to enable businesses to assess the impact of system changes with minimal effort and proactively identify and resolve any issues that were identified in testing.  Real Application Testing option is comprised of two components – SQL Performance Analyzer (SPA) and Database Replay. SPA helps predict the impact of a system change on SQL response time and Database Replay provides the best load testing solution using real production workloads.

Oracle Database Release and above supports now supports "Consolidated Database Replay", a feature that helps businesses assess the impact of database and workload consolidation to a single database.  Consolidated Database Replay supports execution of multiple replays on a single database.

The goal of this article is to provide information on how to use the Consolidated Database Replay functionality.  This article contains information on mandatory patches and also includes usage examples,  a FAQ, and syntax documentation.  

Consolidated Database Replay allows replay of multiple captured production workloads from the same or different systems. The captured workload information includes concurrency, think time, and transaction dependencies, etc.  The captured workloads can then be replayed on a single database maintaining the production characteristics so that any potential issues can be identified and remedied in test before deploying the change to production. This will help customers assess how their database consolidation is going to work and accurately size their infrastructure.

See the following Document for an Example:

<Document 1425020.1> - Database Testing (RAT) Workload Consolidation Feature - Example

NOTE: The use of Real Application Testing thru API/EM interfaces including the Consolidated Database Replay functionality requires licensing of Real Application Testing. Please check the Licensing Information manual on OTN for details.


Oracle® Database Licensing Information
12c Release 1 (12.1)
Part number E17614-08
Chapter 2 Options and Packs
Oracle Real Application Testing


Click here to download the document
Click here to download example scripts


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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