About Oracle Real Application Testing

You can use Oracle Real Application Testing to capture a workload on a production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload.

Oracle Real Application Testing provides an accurate method to test the impact of a variety of system changes and enables you to perform the following tasks:

• You can test the effects of a system change on a workload without affecting the production system.

• You can capture a workload on a production system and simulate the same workload on a test system.

You can use Oracle Database Replay to capture a workload from either an Autonomous Database instance or an on-premises database or any other cloud service database, and replay the workload on Autonomous Database. This enables you to compare how a workload runs on an Autonomous Database with another Autonomous Database, an on-premises database, or some other cloud service database.

Real Application Testing enables you to do any of the following Capture-Replay actions:

Capture Replay Option	Description
Capture-Replay Workloads between Autonomous Databases.	See Capture-Replay Workloads between Autonomous Databases for more information.
Capture Workload from Autonomous Database Oracle Database 19c and Replay on Autonomous Database with Oracle Database 23ai	This Capture-Replay allows you to capture a workload on an Autonomous Database with Oracle Database 19c and replay on an Autonomous Database with Oracle Database 23ai. See Test 19c Workloads on a on 23ai Refreshable Clone with Capture-Replay for more information.
Capture a Workload from a non-Autonomous Database and Replay on Autonomous Database.	See Capture-Replay Workloads between non-Autonomous and Autonomous Databases for more information.
Capture a workload from a production Autonomous Database and replay it on a target Autonomous Database at a different patch level (after a patch is applied to the target Autonomous Database).	See Test Workloads Against an Upcoming Patch for more information.