DBA_WORKLOAD_REPLAYS

DBA_WORKLOAD_REPLAYS displays all the workload replays that have been performed in the current database. It also lists replays on which DBMS_WORKLOAD_REPLAY.GET_REPLAY_INFO() has been called. Each row contains information about one workload replay.

Column	Datatype	NULL	Description
`ID`	`NUMBER`	`NOT NULL`	Internal key for the workload replay
`NAME`	`VARCHAR2(100)`	`NOT NULL`	Name of the workload replay
`DBID`	`NUMBER`	`NOT NULL`	ID of the database in which the workload was replayed
`DBNAME`	`VARCHAR2(10)`	`NOT NULL`	Name of the database in which the workload was replayed
`DBVERSION`	`VARCHAR2(30)`	`NOT NULL`	Version of the database in which the workload was replayed
`PARALLEL`	`VARCHAR2(3)`		Indicates whether the database in which the workload was replayed was an Oracle RAC database (`YES`) or a single instance database (`NO`)
`DIRECTORY`	`VARCHAR2(30)`	`NOT NULL`	Name of the directory object for the workload replay
`CAPTURE_ID`	`NUMBER`		ID of the capture (`DBA_WORKLOAD_CAPTURES.ID`) that was replayed
`STATUS`	`VARCHAR2(40)`	`NOT NULL`	Current status of the workload replay: `PREPARE` - Workload prepare has been started and is waiting for clients to join `IN PROGRESS` - Workload replay is in progress `COMPLETED` - Workload replay has successfully completed `CANCELLED` - Workload replay or the workload prepare has been cancelled `FAILED` - Workload replay was aborted due to errors encountered. See the `COMMENTS` column for further information.
`PREPARE_TIME`	`DATE`		Datetime at which the workload prepare started
`START_TIME`	`DATE`		Datetime when the replay began
`END_TIME`	`DATE`		Datetime when the replay completed or cancelled; NULL if the replay is still in progress
`DURATION_SECS`	`NUMBER`		Duration of the workload replay (in seconds)
`NUM_CLIENTS`	`NUMBER`	`NOT NULL`	Number of workload replay client processes that were used in this workload replay
`NUM_CLIENTS_DONE`	`NUMBER`	`NOT NULL`	Number of workload replay client processes that have finished replay
`FILTER_SET_NAME`^Footref 1	`VARCHAR2(1000)`		Name of the filter set used for the replay
`DEFAULT_ACTION`	`VARCHAR2(30)`	`NOT NULL`	Reserved for future use
`SYNCHRONIZATION`	`VARCHAR2(5)`		Indicates whether recorded transaction semantics should be maintained (`TRUE`) or not (`FALSE`) When synchronization is on, the commit order observed during the original workload capture will be preserved. Every action that is replayed will be executed only after all of its dependent commits have been executed. Dependent commits are commits that were issued before the given action in the original workload capture. See Also: `DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY()` in Oracle Database PL/SQL Packages and Types Reference for a detailed explanation of this replay parameter
`CONNECT_TIME_SCALE`	`NUMBER`	`NOT NULL`	Connection time scaling factor for captured streams during replay. The value is interpreted as a percentage.The default value of 100 means 100 percent. See Also: `DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY()` in Oracle Database PL/SQL Packages and Types Reference for a detailed explanation of this replay parameter
`THINK_TIME_SCALE`	`NUMBER`	`NOT NULL`	Think time scaling factor for captured streams during replay. It scales the thinking time elapsed between two successive user calls from the same captured stream. The input is interpreted as a percentage. The default value of 100 means 100 percent. See Also: `DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY()` in Oracle Database PL/SQL Packages and Types Reference for a detailed explanation of this replay parameter
`THINK_TIME_AUTO_CORRECT`	`VARCHAR2(5)`		Indicates whether the think time should be automatically corrected between calls (`TRUE`) or not (`FALSE`) A value of `TRUE` either reduces think time if replay goes slower than capture or increases think time if replay goes faster than capture. A value of `FALSE` results in no action. See Also: `DBMS_WORKLOAD_REPLAY.PREPARE_REPLAY()` in Oracle Database PL/SQL Packages and Types Reference for a detailed explanation of this replay parameter
`USER_CALLS`	`NUMBER`		Total number of user calls replayed
`DBTIME`	`NUMBER`		Accumulated database time for the replay
`NETWORK_TIME`	`NUMBER`		Accumulated network time for the replay
`THINK_TIME`	`NUMBER`		Accumulated think time for the replay
`ELAPSED_TIME_DIFF`	`NUMBER`		Reserved for future use
`AWR_DBID`	`NUMBER`		Database ID of the AWR snapshots that correspond to this workload replay. For replays that were performed in the current database, this value is equal to the current database's DBID. For replays that were performed in other databases, this value will either be NULL or will be populated by `DBMS_WORKLOAD_REPLAY.IMPORT_AWR()`.
`AWR_BEGIN_SNAP`	`NUMBER`		Begin snapshot ID of the AWR snapshots that correspond to this workload replay
`AWR_END_SNAP`	`NUMBER`		End snapshot ID of the AWR snapshots that correspond to this workload replay
`AWR_EXPORTED`	`VARCHAR2(12)`		Indicates whether the AWR snapshots that correspond to this workload replay have been exported using `DBMS_WORKLOAD_REPLAY.EXPORT_AWR()` (`YES`) or not (`NO`), or whether AWR snapshots cannot be exported because the replay is still in progress, has run to completion successfully, or was done in a different database from which it was not exported (`NOT POSSIBLE`)
`ERROR_CODE`	`NUMBER`		Error code for this workload replay
`ERROR_MESSAGE`	`VARCHAR2(300)`		Error message for this workload replay
`DIR_PATH`	`VARCHAR2(4000)`	`NOT NULL`	Full directory path for the replay directory object
`SQLSET_OWNER`^Foot 1	`VARCHAR2(30)`		User name of the SQL tuning set owner
`SQLSET_NAME`^Footref 1	`VARCHAR2(30)`		Name of the SQL tuning set for this workload replay

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).