Oracle Cloud Infrastructure Documentation

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 AI Database instance or an on-premises database or any other cloud service database, and replay the workload on Autonomous AI Database. This enables you to compare how a workload runs on an Autonomous AI Database with another Autonomous AI 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 AI Databases.

See Capture-Replay Workloads between Autonomous Databases for more information.

Capture Workload from Autonomous AI Database Oracle Database 19c and Replay on Autonomous AI Database with Oracle AI Database 26ai

This Capture-Replay allows you to capture a workload on an Autonomous AI Database with Oracle Database 19c and replay on an Autonomous AI Database with Oracle AI Database 26ai.

See Test 19c Workloads on an Oracle AI Database 26ai Clone with Capture-Replay for more information.

Capture a Workload from a non-Autonomous AI Database and Replay on Autonomous AI Database.

See Capture-Replay Workloads between non-Autonomous and Autonomous Databases for more information.

Capture a workload from a production Autonomous AI Database and replay it on a target Autonomous AI Database at a different patch level (after a patch is applied to the target Autonomous AI Database).

See Test Workloads Against an Upcoming Patch for more information.