[Home] [Help] [Dependency Information]
Object Name: | GV_$PROPAGATION_RECEIVER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
SRC_QUEUE_SCHEMA | VARCHAR2 | (30) | ||
SRC_QUEUE_NAME | VARCHAR2 | (30) | ||
SRC_DBNAME | VARCHAR2 | (128) | ||
DST_QUEUE_SCHEMA | VARCHAR2 | (30) | ||
DST_QUEUE_NAME | VARCHAR2 | (30) | ||
STARTUP_TIME | DATE | |||
HIGH_WATER_MARK | NUMBER | |||
ACKNOWLEDGEMENT | NUMBER | |||
LAST_RECEIVED_MSG | NUMBER | |||
TOTAL_MSGS | NUMBER | |||
ELAPSED_UNPICKLE_TIME | NUMBER | |||
ELAPSED_RULE_TIME | NUMBER | |||
ELAPSED_ENQUEUE_TIME | NUMBER | |||
SESSION_ID | NUMBER | |||
SERIAL# | NUMBER | |||
SPID | VARCHAR2 | (24) | ||
PROPAGATION_NAME | VARCHAR2 | (30) | ||
STATE | VARCHAR2 | (43) | ||
LAST_RECEIVED_MSG_POSITION | RAW | (64) | ||
ACKNOWLEDGEMENT_POSITION | RAW | (64) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, SRC_QUEUE_SCHEMA
, SRC_QUEUE_NAME
, SRC_DBNAME
, DST_QUEUE_SCHEMA
, DST_QUEUE_NAME
, STARTUP_TIME
, HIGH_WATER_MARK
, ACKNOWLEDGEMENT
, LAST_RECEIVED_MSG
, TOTAL_MSGS
, ELAPSED_UNPICKLE_TIME
, ELAPSED_RULE_TIME
, ELAPSED_ENQUEUE_TIME
, SESSION_ID
, SERIAL#
, SPID
, PROPAGATION_NAME
, STATE
, LAST_RECEIVED_MSG_POSITION
, ACKNOWLEDGEMENT_POSITION
, CON_ID
FROM SYS.GV_$PROPAGATION_RECEIVER;
|
|
|