4.150 ALL_TXEVENTQ_SUBSCRIBER_STAT

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

Related Views

  • DBA_TXEVENTQ_SUBSCRIBER_STAT describes subscriber statistics for all Transactional Event Queues (TxEventQs) in the database.

  • USER_TXEVENTQ_SUBSCRIBER_STAT describes subscriber statistics for Transactional Event Queues (TxEventQs) that are owned by the current user. This view does not display the OWNER column.

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: