DBA_WORKLOAD_SCHEDULE_CAPTURES

DBA_WORKLOAD_SCHEDULE_CAPTURES displays the workload captures used by replay schedules. Each row in the view contains information about one workload capture.

Column	Datatype	NULL	Description
`SCHEDULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	The name of a schedule to be replayed
`SCHEDULE_CAP_ID`	`NUMBER`	`NOT NULL`	Identifies a workload capture added to a replay schedule. It starts with `1`. If the same capture is added multiple times to a schedule, there will be multiple rows with different `SCHEDULE_CAP_ID` columns and identical `CAPTURE_ID` columns.
`CAPTURE_ID`	`NUMBER`	`NOT NULL`	Points to the capture ID from `DBA_WORKLOAD_CAPTURES`.
`CAPTURE_DIR`	`VARCHAR2(128)`	`NOT NULL`	Name of the directory object for workload capture
`OS_SUBDIR`	`VARCHAR2(4000)`	`NOT NULL`	Name of the subdirectory under the replay directory for this workload capture
`MAX_CONCURRENT_SESSIONS`	`NUMBER`		The maximal number of concurrent sessions that was seen in this workload capture
`NUM_CLIENTS_ASSIGNED`	`NUMBER`		Number of clients assigned to this workload capture before replay starts
`NUM_CLIENTS`	`NUMBER`		Number of clients that are running for this workload capture during replay
`NUM_CLIENTS_DONE`	`NUMBER`		Number of clients that have finished the replay of this workload capture
`STOP_REPLAY`	`VARCHAR2(1)`	`NOT NULL`	Indicates whether the whole replay will stop once the replay of this workload capture is done (`Y`) or not (`N`)
`TAKE_BEGIN_SNAPSHOT`	`VARCHAR2(1)`	`NOT NULL`	Indicates whether an AWR snapshot will be taken when the replay of this capture starts (`Y`) or not (`N`)
`TAKE_END_SNAPSHOT`	`VARCHAR2(1)`	`NOT NULL`	Indicates whether an AWR snapshot will be taken when the replay of this capture finishes (`Y`) or not (`N`)
`QUERY_ONLY`	`VARCHAR2(1)`	`NOT NULL`	Indicates whether only the query-only workload from the current workload capture will be replayed, skipping all the DML/DDL that might update the database (`Y`) or not (`N`)
`START_DELAY_SECS`	`NUMBER`		Displays the wait time (in seconds) when the replay of a workload capture is ready to start. "Ready to start" means the capture does not wait for any other capture, or all the captures for which it should wait have already been replayed. The default value is 0.
`START_TIME`	`DATE`		Start time for the replay of this capture
`END_TIME`	`DATE`		Finish time for the replay of this capture
`AWR_DBID`	`NUMBER`		AWR database ID of the replay
`AWR_BEGIN_SNAP`	`NUMBER`		AWR snapshot ID when the replay starts
`AWR_END_SNAP`	`NUMBER`		AWR snapshot ID when the replay finishes