DBA Data[Home] [Help]

VIEW: SYS.DBA_WORKLOAD_SCHEDULE_CAPTURES

Source

View Text - Preformatted

select schedule_name, schedule_cap_id, capture_id,
        capture_dir, os_subdir, max_concurrent_sessions,
        num_clients_assigned, num_clients,
        num_clients_done, stop_replay, take_begin_snapshot,
        take_end_snapshot, query_only, start_delay_secs,
        start_time,end_time,awr_dbid,awr_begin_snap,awr_end_snap
 from   WRR$_SCHEDULE_CAPTURES
View Text - HTML Formatted

SELECT SCHEDULE_NAME
, SCHEDULE_CAP_ID
, CAPTURE_ID
, CAPTURE_DIR
, OS_SUBDIR
, MAX_CONCURRENT_SESSIONS
, NUM_CLIENTS_ASSIGNED
, NUM_CLIENTS
, NUM_CLIENTS_DONE
, STOP_REPLAY
, TAKE_BEGIN_SNAPSHOT
, TAKE_END_SNAPSHOT
, QUERY_ONLY
, START_DELAY_SECS
, START_TIME
, END_TIME
, AWR_DBID
, AWR_BEGIN_SNAP
, AWR_END_SNAP
FROM WRR$_SCHEDULE_CAPTURES