Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 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).