[Home] [Help] [Dependency Information]
Object Name: | CDB_XSTREAM_SPLIT_MERGE_HIST |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
history view of details of split/merge jobs/status about XStream in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORIGINAL_CAPTURE_NAME | VARCHAR2 | (128) | Yes | name of the original capture |
CLONED_CAPTURE_NAME | VARCHAR2 | (128) | name of the cloned capture | |
ORIGINAL_QUEUE_OWNER | VARCHAR2 | (128) | name of original queue owner | |
ORIGINAL_QUEUE_NAME | VARCHAR2 | (128) | name of original queue | |
CLONED_QUEUE_OWNER | VARCHAR2 | (128) | name of cloned queue owner | |
CLONED_QUEUE_NAME | VARCHAR2 | (128) | name of cloned queue | |
ORIGINAL_CAPTURE_STATUS | VARCHAR2 | (8) | status of the original capture | |
CLONED_CAPTURE_STATUS | VARCHAR2 | (8) | status of the cloned capture | |
ORIGINAL_XSTREAM_NAME | VARCHAR2 | (128) | name of original XStream (propagation or local apply) | |
CLONED_XSTREAM_NAME | VARCHAR2 | (128) | name of cloned XStream (propagation or local apply) | |
XSTREAM_TYPE | VARCHAR2 | (11) | type of XStream (propagation or local apply) | |
RECOVERABLE_SCRIPT_ID | RAW | (16) | unique oid of the script to split or merge XStream | |
SCRIPT_STATUS | VARCHAR2 | (12) | status of the script to split or merge XStream | |
ACTION_TYPE | VARCHAR2 | (7) | type of action performed on this XStream (either split or merge) | |
ACTION_THRESHOLD | VARCHAR2 | (40) | value of split_threshold or merge_threshold | |
STATUS | VARCHAR2 | (16) | status of XStream | |
STATUS_UPDATE_TIME | TIMESTAMP(6) | (11) | time when status was last updated | |
CREATION_TIME | TIMESTAMP(6) | (11) | time when this row was created | |
LAG | NUMBER | the time in seconds that the cloned capture lags behind the original capture | ||
JOB_OWNER | VARCHAR2 | (128) | name of the owner of the job | |
JOB_NAME | VARCHAR2 | (128) | name of the job to split or merge XStream | |
ERROR_NUMBER | NUMBER | Error number if the capture process was aborted | ||
ERROR_MESSAGE | VARCHAR2 | (4000) | Error message if the capture process was aborted | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT ORIGINAL_CAPTURE_NAME
, CLONED_CAPTURE_NAME
, ORIGINAL_QUEUE_OWNER
, ORIGINAL_QUEUE_NAME
, CLONED_QUEUE_OWNER
, CLONED_QUEUE_NAME
, ORIGINAL_CAPTURE_STATUS
, CLONED_CAPTURE_STATUS
, ORIGINAL_XSTREAM_NAME
, CLONED_XSTREAM_NAME
, XSTREAM_TYPE
, RECOVERABLE_SCRIPT_ID
, SCRIPT_STATUS
, ACTION_TYPE
, ACTION_THRESHOLD
, STATUS
, STATUS_UPDATE_TIME
, CREATION_TIME
, LAG
, JOB_OWNER
, JOB_NAME
, ERROR_NUMBER
, ERROR_MESSAGE
, CON_ID
FROM SYS.CDB_XSTREAM_SPLIT_MERGE_HIST;
SYS.CDB_XSTREAM_SPLIT_MERGE_HIST does not reference any database object
SYS.CDB_XSTREAM_SPLIT_MERGE_HIST is referenced by following:
|
|
|