4.27 ALL_QUEUE_EVENT_STREAMS

ALL_QUEUE_EVENT_STREAMS describes the Transactional Event Queue (TxEventQ) event streams accessible to the current user.

Related Views

  • DBA_QUEUE_EVENT_STREAMS describes all TxEventQ event streams in the database.

  • USER_QUEUE_EVENT_STREAMS describes the TxEventQ event streams owned by 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

BASE_QUEUE_ID

NUMBER

  

If the queue is an exception queue, then this column displays the base queue ID

EVENT_STREAM_ID

NUMBER

NOT NULL

Event stream ID

DELAY_EVENT_STREAM_ID

NUMBER

Delay event stream ID

ENQUEUE_INSTANCE

NUMBER

NOT NULL

Event stream enqueue instance ID

EVENT_STREAM_TYPE

VARCHAR2(10)

Type of event stream. Possible values:

  • VOLATILE
  • PERSISTENT

See Also: