ALL_TXEVENTQ_SUBSCRIBER_STAT

ALL_TXEVENTQ_SUBSCRIBER_STAT displays subscriber statistics for Transactional Event Queues (TxEventQs) that are accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the queue
NAME VARCHAR2(128) NOT NULL Name of the queue
QUEUE_ID NUMBER NOT NULL Queue ID
EVENT_STREAM_ID NUMBER   Event stream ID
PRIORITY NUMBER   Priority of the messages in the event stream
SUBSCRIBER_ID NUMBER   Subscriber ID
ENQUEUED_MSGS NUMBER  

Number of messages enqueued for the subcriber

For rule-based subscribers, only messages that qualify for the subscriber are counted as enqueued.
DEQUEUED_MSGS NUMBER  

Number of messages dequeued for the subcriber

For rule-based subscribers, only messages that qualify for the subscriber and are successfully dequeued are counted as dequeued.
EXPIRED_MSGS NUMBER   Number of messages that were marked as expired before being dequeued by the subscriber
SKIPPED_MSGS NUMBER  

Number of messages marked as skipped for rule-based subscribers

Messages that do not qualify for the subscriber's rule are marked as skipped.
RETENTION_TIME_ELAPSED_MSGS NUMBER  

Number of messages whose retention time elapsed before being dequeued by the subscriber and were therefore marked for purging from the queue

This count is incremented only when the queue-level parameter RETENTION_TYPE is set to 1, meaning retention is computed with reference to the message ENQUEUE_TIME. Messages can be purged after the number of seconds specified by the RETENTION_TIME parameter has elapsed.

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.1.

See Also: