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 |
For internal use only. |
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 |
Note:
This view is available starting with Oracle Database 11g Release 2 (11.2.0.4).