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]

TABLE: SYS.WRR$_CAPTURES

Object Details

Object Name:	WRR$_CAPTURES
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: WRR$_CAPTURES_PK

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRR$_CAPTURES_PK	NORMAL	UNIQUE	SYSTEM	ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes
NAME	VARCHAR2	(128)	Yes
DBID	NUMBER		Yes
DBNAME	VARCHAR2	(10)	Yes
DBVERSION	VARCHAR2	(128)	Yes
DIRECTORY	VARCHAR2	(128)	Yes
DIR_PATH	VARCHAR2	(4000)	Yes
DIR_PATH_SHARED	VARCHAR2	(10)	Yes
STATUS	VARCHAR2	(40)	Yes	One of "IN PROGRESS", "COMPLETED" or "FAILED"
START_TIME	DATE		Yes
END_TIME	DATE
START_SCN	NUMBER		Yes
END_SCN	NUMBER
DEFAULT_ACTION	VARCHAR2	(30)	Yes	One of "INCLUDE" or "EXCLUDE"
AWR_DBID	NUMBER
AWR_BEGIN_SNAP	NUMBER
AWR_END_SNAP	NUMBER
AWR_EXPORTED	NUMBER
ERROR_CODE	NUMBER
ERROR_MSG	VARCHAR2	(300)
COMMENTS	VARCHAR2	(4000)
LAST_PREP_VERSION	VARCHAR2	(128)
WORKLOAD_ID	VARCHAR2	(40)
SQLSET_OWNER	VARCHAR2	(128)
SQLSET_NAME	VARCHAR2	(128)
INTERNAL_START_TIME	NUMBER

Query Text

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


SELECT ID
,      NAME
,      DBID
,      DBNAME
,      DBVERSION
,      DIRECTORY
,      DIR_PATH
,      DIR_PATH_SHARED
,      STATUS
,      START_TIME
,      END_TIME
,      START_SCN
,      END_SCN
,      DEFAULT_ACTION
,      AWR_DBID
,      AWR_BEGIN_SNAP
,      AWR_END_SNAP
,      AWR_EXPORTED
,      ERROR_CODE
,      ERROR_MSG
,      COMMENTS
,      LAST_PREP_VERSION
,      WORKLOAD_ID
,      SQLSET_OWNER
,      SQLSET_NAME
,      INTERNAL_START_TIME
FROM SYS.WRR$_CAPTURES;

Dependencies

[top of page]

SYS.WRR$_CAPTURES does not reference any database object

SYS.WRR$_CAPTURES is referenced by following:

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