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 laterOracle 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 11.2.0.2.0 and later
Information in this document applies to any platform.
Applies to:
Oracle Server - Enterprise Edition - Version: 11.2.0.2.0 and above
Information in this document applies to any platform.
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
12c Release 1 (12.1)
Part number E17614-08
Chapter 2 Options and Packs
Oracle Real Application Testing
http://docs.oracle.com/cd/E16655_01/license.121/e17614/options.htm#DBLIC154
Actions
Contacts
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |