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_CAPTURES

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
DBID	NUMBER		Yes
DBNAME	VARCHAR2	(10)	Yes
DBVERSION	VARCHAR2	(128)	Yes
PARALLEL	VARCHAR2	(3)
DIRECTORY	VARCHAR2	(128)	Yes
STATUS	VARCHAR2	(40)	Yes
START_TIME	DATE		Yes
END_TIME	DATE
DURATION_SECS	NUMBER
START_SCN	NUMBER		Yes
END_SCN	NUMBER
DEFAULT_ACTION	VARCHAR2	(30)	Yes
FILTERS_USED	NUMBER
CAPTURE_SIZE	NUMBER
DBTIME	NUMBER
DBTIME_TOTAL	NUMBER
USER_CALLS	NUMBER
USER_CALLS_TOTAL	NUMBER
USER_CALLS_UNREPLAYABLE	NUMBER
TRANSACTIONS	NUMBER
TRANSACTIONS_TOTAL	NUMBER
CONNECTS	NUMBER
CONNECTS_TOTAL	NUMBER
ERRORS	NUMBER
AWR_DBID	NUMBER
AWR_BEGIN_SNAP	NUMBER
AWR_END_SNAP	NUMBER
AWR_EXPORTED	VARCHAR2	(12)
ERROR_CODE	NUMBER
ERROR_MESSAGE	VARCHAR2	(300)
DIR_PATH	VARCHAR2	(4000)	Yes
DIR_PATH_SHARED	VARCHAR2	(10)	Yes
LAST_PROCESSED_VERSION	VARCHAR2	(128)
SQLSET_OWNER	VARCHAR2	(128)
SQLSET_NAME	VARCHAR2	(128)

Query Text

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


SELECT ID
,      NAME
,      DBID
,      DBNAME
,      DBVERSION
,      PARALLEL
,      DIRECTORY
,      STATUS
,      START_TIME
,      END_TIME
,      DURATION_SECS
,      START_SCN
,      END_SCN
,      DEFAULT_ACTION
,      FILTERS_USED
,      CAPTURE_SIZE
,      DBTIME
,      DBTIME_TOTAL
,      USER_CALLS
,      USER_CALLS_TOTAL
,      USER_CALLS_UNREPLAYABLE
,      TRANSACTIONS
,      TRANSACTIONS_TOTAL
,      CONNECTS
,      CONNECTS_TOTAL
,      ERRORS
,      AWR_DBID
,      AWR_BEGIN_SNAP
,      AWR_END_SNAP
,      AWR_EXPORTED
,      ERROR_CODE
,      ERROR_MESSAGE
,      DIR_PATH
,      DIR_PATH_SHARED
,      LAST_PROCESSED_VERSION
,      SQLSET_OWNER
,      SQLSET_NAME
FROM SYS.DBA_WORKLOAD_CAPTURES;

Dependencies

[top of page]

SYS.DBA_WORKLOAD_CAPTURES references the following:

SYS: WRR$_CAPTURES; WRR$_CAPTURE_STATS; WRR$_FILTERS

SYS.DBA_WORKLOAD_CAPTURES is referenced by following:

PUBLIC: DBA_WORKLOAD_CAPTURES
SYS: DBMS_FEATURE_WCR_CAPTURE - show dependent code; DBMS_RAT_MASK - show dependent code; DBMS_WORKLOAD_CAPTURE - show dependent code; DBMS_WORKLOAD_REPLAY - show dependent code; DBMS_WRR_INTERNAL - show dependent code