[Home] [Help] [Dependency Information]
Object Name: | GV_$PROPAGATION_SENDER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
QUEUE_ID | NUMBER | |||
QUEUE_SCHEMA | VARCHAR2 | (30) | ||
QUEUE_NAME | VARCHAR2 | (30) | ||
DST_QUEUE_SCHEMA | VARCHAR2 | (30) | ||
DST_QUEUE_NAME | VARCHAR2 | (30) | ||
STARTUP_TIME | DATE | |||
DBLINK | VARCHAR2 | (128) | ||
HIGH_WATER_MARK | NUMBER | |||
ACKNOWLEDGEMENT | NUMBER | |||
SCHEDULE_STATUS | VARCHAR2 | (30) | ||
TOTAL_MSGS | NUMBER | |||
TOTAL_BYTES | NUMBER | |||
ELAPSED_DEQUEUE_TIME | NUMBER | |||
ELAPSED_PICKLE_TIME | NUMBER | |||
ELAPSED_PROPAGATION_TIME | NUMBER | |||
ELAPSED_RULE_TIME | NUMBER | |||
MAX_NUM_PER_WIN | NUMBER | |||
MAX_SIZE | NUMBER | |||
LAST_MSG_LATENCY | NUMBER | |||
LAST_MSG_ENQUEUE_TIME | TIMESTAMP(6) | (20) | ||
LAST_MSG_PROPAGATION_TIME | TIMESTAMP(6) | (20) | ||
LAST_LCR_LATENCY | NUMBER | |||
LAST_LCR_CREATION_TIME | DATE | |||
LAST_LCR_PROPAGATION_TIME | DATE | |||
DST_DATABASE_NAME | VARCHAR2 | (128) | ||
SESSION_ID | NUMBER | |||
SERIAL# | NUMBER | |||
SPID | VARCHAR2 | (24) | ||
PROPAGATION_NAME | VARCHAR2 | (30) | ||
STATE | VARCHAR2 | (53) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, QUEUE_ID
, QUEUE_SCHEMA
, QUEUE_NAME
, DST_QUEUE_SCHEMA
, DST_QUEUE_NAME
, STARTUP_TIME
, DBLINK
, HIGH_WATER_MARK
, ACKNOWLEDGEMENT
, SCHEDULE_STATUS
, TOTAL_MSGS
, TOTAL_BYTES
, ELAPSED_DEQUEUE_TIME
, ELAPSED_PICKLE_TIME
, ELAPSED_PROPAGATION_TIME
, ELAPSED_RULE_TIME
, MAX_NUM_PER_WIN
, MAX_SIZE
, LAST_MSG_LATENCY
, LAST_MSG_ENQUEUE_TIME
, LAST_MSG_PROPAGATION_TIME
, LAST_LCR_LATENCY
, LAST_LCR_CREATION_TIME
, LAST_LCR_PROPAGATION_TIME
, DST_DATABASE_NAME
, SESSION_ID
, SERIAL#
, SPID
, PROPAGATION_NAME
, STATE
, CON_ID
FROM SYS.GV_$PROPAGATION_SENDER;
|
|
|