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

Last updated on FEBRUARY 09, 2024

Applies to:

Details

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 11.2.0.2.0 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

Actions

Contacts