SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
QUEUE_SCHEMA |
VARCHAR2(30) |
NOT NULL |
Owner of the queue |
QUEUE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the queue |
SUBSCRIBER_ID |
NUMBER |
NOT NULL |
Internal subscriber number (for identification) |
SUBSCRIBER_NAME |
VARCHAR2(30) |
|
Name of the subscriber |
SUBSCRIBER_ADDRESS |
VARCHAR2(1024) |
|
Address of the subscribing agent |
SUBSCRIBER_TYPE |
VARCHAR2(30) |
|
Type of subscriber:
-
PROXY - Proxy subscriber
-
SUBSCRIBOR
|
STARTUP_TIME |
DATE |
NOT NULL |
Startup time of the instance |
NUM_MSGS |
NUMBER |
|
Total number of outstanding messages currently enqueued in the buffered queue for the subscriber (includes the count of the messages overflowed to disk) |
CNUM_MSGS |
NUMBER |
|
Cumulative total number of messages enqueued for the subscriber since the creation of the buffered queue |
TOTAL_SPILLED_MSG |
NUMBER |
|
Total number of spilled messages for the subscriber |
