8.204 V$EQ_INACTIVE_PARTITIONS

V$EQ_INACTIVE_PARTITIONS describes all inactive Transactional Event Queue (TEQ) event stream partitions.

Column	Datatype	Description
QUEUE	NUMBER	Queue ID
EVENT_STREAM_ID	NUMBER	Event stream ID
PRIORITY	NUMBER	Priority of the event stream partition
EVENT_STREAM_PARTITION_ID	NUMBER	Event stream partition ID
OPT_STATE	VARCHAR2(19)	Current message cache optimizer state of the event stream partition. Possible values: EMPTY CACHED EVICTION_PROGRESS EVICTED UNEVICTION_PROGRESS PREFETCH_PROGRESS NA: Error in the message cache optimizer state of the event stream partition
OPT_TIME	TIMESTAMP(3) WITH TIME ZONE	The predicted absolute time when the event stream partition could be accessed in future
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 21c.

See Also:

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