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.

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.