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

Object Details

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

in all containers

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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)
CON_ID	NUMBER			container id

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
,      CON_ID
FROM SYS.CDB_WORKLOAD_CAPTURES;

Dependencies

[top of page]

SYS.CDB_WORKLOAD_CAPTURES does not reference any database object

SYS.CDB_WORKLOAD_CAPTURES is referenced by following:

PUBLIC: CDB_WORKLOAD_CAPTURES