[Home] [Help] [Dependency Information]
Object Name: | DBA_WORKLOAD_CAPTURES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
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) |
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;
|
|
|