My Oracle Support Banner

Using Workload Capture and Replay (Doc ID 445116.1)

Last updated on FEBRUARY 04, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

The goal of this Document is to give the reader an introduction to the Data Testing feature.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Before you begin
 Restrictions
 Capturing a workload
 Create a directory to hold the workload information
 Start the database in restricted mode
 Start the Capture
 At this point the work now being done will be captured by the RDBMS
 Using filters with workload capture
  Displaying information on a capture
 Running an AWR report for the period of the capture
 Database Replay
 Preparing for the replay
 Executing the replay
 Connection Maps
References

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