[Home] [Help] [Dependency Information]
Object Name: | WRR$_CAPTURES |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRR$_CAPTURES_PK | NORMAL | UNIQUE | SYSTEM | ID |
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 |
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;
SYS.WRR$_CAPTURES does not reference any database object
SYS.WRR$_CAPTURES is referenced by following:
|
|
|