[Home] [Help] [Dependency Information]
Object Name: | DEF$_DESTINATION |
---|---|
Object Type: | TABLE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Information about propagation to different destinations
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
DEF$_DESTINATION_PRIMARY | NORMAL | UNIQUE | SYSTEM |
DBLINK
CATCHUP |
Table | |
Foreign Table | Foreign Key Column | DEF$_CALLDEST | DEF$_DESTINATION |
DEF$_CALLDEST
DBLINK
DEF$_CALLDEST CATCHUP |
REPCAT$_REPSCHEMA | DEF$_DESTINATION |
REPCAT$_REPSCHEMA
DBLINK
REPCAT$_REPSCHEMA EXTENSION_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DBLINK | VARCHAR2 | (128) | Yes | Destination |
LAST_DELIVERED | NUMBER | Yes | Value of delivery_order of last transaction propagated | |
LAST_ENQ_TID | VARCHAR2 | (22) | Transaction ID of last transaction propagated | |
LAST_SEQ | NUMBER | Parallel prop seq number of last transaction propagated | ||
DISABLED | CHAR | (1) | Is propagation to destination disabled | |
JOB | NUMBER | Number of job that pushes queue | ||
LAST_TXN_COUNT | NUMBER | Number of transactions pushed during last attempt | ||
LAST_ERROR_NUMBER | NUMBER | Oracle error number from last push | ||
LAST_ERROR_MESSAGE | VARCHAR2 | (2000) | Error message from last push | |
APPLY_INIT | VARCHAR2 | (4000) | ||
FLAG | RAW | (4) | ||
CATCHUP | RAW | (16) | Yes | Used to break transaction into pieces |
ALTERNATE | CHAR | (1) | Used to break transaction into pieces | |
TOTAL_TXN_COUNT | NUMBER | Total number of transactions pushed | ||
TOTAL_PROP_TIME_LATENCY | NUMBER | Total propagation time in seconds for measuring latency | ||
TOTAL_PROP_TIME_THROUGHPUT | NUMBER | Total propagation time in seconds for measuring throughput | ||
TO_COMMUNICATION_SIZE | NUMBER | Total number of bytes sent to this dblink | ||
FROM_COMMUNICATION_SIZE | NUMBER | Total number of bytes received from this dblink | ||
SPARE1 | NUMBER | Total number of round trips for this dblink | ||
SPARE2 | NUMBER | Total number of administrative requests | ||
SPARE3 | NUMBER | Total number of error transactions pushed | ||
SPARE4 | NUMBER | Total time in seconds spent sleeping during push |
Cut, paste (and edit) the following text to query this object:
SELECT DBLINK
, LAST_DELIVERED
, LAST_ENQ_TID
, LAST_SEQ
, DISABLED
, JOB
, LAST_TXN_COUNT
, LAST_ERROR_NUMBER
, LAST_ERROR_MESSAGE
, APPLY_INIT
, FLAG
, CATCHUP
, ALTERNATE
, TOTAL_TXN_COUNT
, TOTAL_PROP_TIME_LATENCY
, TOTAL_PROP_TIME_THROUGHPUT
, TO_COMMUNICATION_SIZE
, FROM_COMMUNICATION_SIZE
, SPARE1
, SPARE2
, SPARE3
, SPARE4
FROM SYSTEM.DEF$_DESTINATION;
SYSTEM.DEF$_DESTINATION does not reference any database object
SYSTEM.DEF$_DESTINATION is referenced by following:
|
|
|