Oracle Cloud Infrastructure Documentation

Real Application Testing Capture Replay Views

Oracle Real Application Testing capture replay views.

  • DBA_CAPTURE_REPLAY_HISTORY View
    The DBA_CAPTURE_REPLAY_HISTORY view provides historical information for all your workload captures and replays.
  • DBA_CAPTURE_REPLAY_STATUS View
    The DBA_CAPTURE_REPLAY_STATUS view provides the most recent status for your workload. The values in the view are updated when you execute FINISH_WORKLOAD_CAPTURE, CANCEL_WORKLOAD_CAPTURE or REPLAY_WORKLOAD.

Parent topic: Autonomous Database Views

DBA_CAPTURE_REPLAY_HISTORY View

The DBA_CAPTURE_REPLAY_HISTORY view provides historical information for all your workload captures and replays.

Column Datatype Description
NAME VARCHAR2(32)

Name of the workload capture or replay
UNIQUE_NAME VARCHAR2(64)

Internal unique name for capture or replay
STATUS VARCHAR2(8) Workload capture or replay status
DATABASE_NAME VARCHAR2(128) Name of the database
DATABASE_GUID RAW(16) Unique id of the database
TYPE VARCHAR2(10) Type (capture or replay)
START_TIME DATE Start time of the workload capture or replay.
END_TIME DATE End time of the workload capture or replay.
REPORT_URL VARCHAR2(1000) PAR URL path for capture or replay report.

DBA_CAPTURE_REPLAY_STATUS View

The DBA_CAPTURE_REPLAY_STATUS view provides the most recent status for your workload. The values in the view are updated when you execute FINISH_WORKLOAD_CAPTURE, CANCEL_WORKLOAD_CAPTURE or REPLAY_WORKLOAD.

Column Datatype Description
STATE VARCHAR2(32)

Provides the current status for a workload capture or replay.

For a workload capture, status value could be one of these:

  • CAPTURE capture_name STARTED

  • FINISHING CAPTURE

  • UPLOADING CAPTURE FILES

  • CANCELING CAPTURE

  • CANCEL CAPTURE capture_name COMPLETED

  • FINISH CAPTURE capture_name COMPLETED

For a workload replay, status value could be one of these:

  • DOWNLOADING CAPTURE FILES

  • PROCESSING CAPTURE

  • INITIALIZING REPLAY

  • PREPARING REPLAY

  • STARTING REPLAY

  • UPLOADING REPLAY FILES

  • REPLAY replay_name COMPLETED

PROGRESS VARCHAR2(8)

Percentage completed for download or upload.