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 |
QUEUE_ID |
NUMBER |
NOT NULL |
Identifier for the queue |
FIRST_ACTIVITY_TIME |
TIMESTAMP(6) |
|
First queue activity time since database startup |
ENQUEUED_MSGS |
NUMBER |
|
Number of messages enqueued |
DEQUEUED_MSGS |
NUMBER |
|
Number of messages dequeued
Note: This column will not be incremented until all the subscribers of the message have dequeued the message and its retention time has elapsed.
|
ELAPSED_ENQUEUE_TIME |
NUMBER |
|
Total time (in hundredths of a second) spent doing enqueue |
ELAPSED_DEQUEUE_TIME |
NUMBER |
|
Total time (in hundredths of a second) spent doing dequeue |
ELAPSED_TRANSFORMATION_TIME |
NUMBER |
|
Total time (in hundredths of a second) spent doing transformation |
ELAPSED_RULE_EVALUATION_TIME |
NUMBER |
|
Total time (in hundredths of a second) spent doing rule evaluation |
ENQUEUED_EXPIRY_MSGS |
NUMBER |
|
Number of messages enqueued with expiry |
ENQUEUED_DELAY_MSGS |
NUMBER |
|
Number of messages enqueued with delay |
MSGS_MADE_EXPIRED |
NUMBER |
|
Number of messages expired by time manager |
MSGS_MADE_READY |
NUMBER |
|
Number of messages made ready by time manager |
LAST_ENQUEUE_TIME |
TIMESTAMP(6) |
|
Last message enqueue time |
LAST_DEQUEUE_TIME |
TIMESTAMP(6) |
|
Last message dequeue time |
LAST_TM_EXPIRY_TIME |
TIMESTAMP(6) |
|
Last time message was expired by time manager |
LAST_TM_READY_TIME |
TIMESTAMP(6) |
|
Last time message was made ready by time manager |
