eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_WORKLOAD_SCHEDULE_CAPTURES

Object Details

Object Name:	DBA_WORKLOAD_SCHEDULE_CAPTURES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SCHEDULE_NAME	VARCHAR2	(128)	Yes
SCHEDULE_CAP_ID	NUMBER		Yes
CAPTURE_ID	NUMBER		Yes
CAPTURE_DIR	VARCHAR2	(128)	Yes
OS_SUBDIR	VARCHAR2	(4000)	Yes
MAX_CONCURRENT_SESSIONS	NUMBER
NUM_CLIENTS_ASSIGNED	NUMBER
NUM_CLIENTS	NUMBER
NUM_CLIENTS_DONE	NUMBER
STOP_REPLAY	VARCHAR2	(1)	Yes
TAKE_BEGIN_SNAPSHOT	VARCHAR2	(1)	Yes
TAKE_END_SNAPSHOT	VARCHAR2	(1)	Yes
QUERY_ONLY	VARCHAR2	(1)	Yes
START_DELAY_SECS	NUMBER
START_TIME	DATE
END_TIME	DATE
AWR_DBID	NUMBER
AWR_BEGIN_SNAP	NUMBER
AWR_END_SNAP	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.DBA_WORKLOAD_SCHEDULE_CAPTURES;

Dependencies

[top of page]

SYS.DBA_WORKLOAD_SCHEDULE_CAPTURES references the following:

SYS: WRR$_SCHEDULE_CAPTURES

SYS.DBA_WORKLOAD_SCHEDULE_CAPTURES is referenced by following:

PUBLIC: DBA_WORKLOAD_SCHEDULE_CAPTURES
SYS: DBMS_WORKLOAD_REPLAY - show dependent code; DBMS_WRR_INTERNAL - show dependent code