My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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

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
http://docs.oracle.com/cd/E16655_01/license.121/e17614/options.htm#DBLIC154

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Actions

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

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!


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