4.19 ALL_QUEUE_EVENT_STREAMS

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

Related Views

• DBA_QUEUE_EVENT_STREAMS describes all TEQ event streams in the database.

• USER_QUEUE_EVENT_STREAMS describes the TEQ 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
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

Note:

This view is available starting with Oracle Database 21c.

See Also:

• "DBA_QUEUE_EVENT_STREAMS"

• "USER_QUEUE_EVENT_STREAMS"

• Oracle Database Advanced Queuing User's Guide for more information about Oracle Transactional Event Queues and Advanced Queuing