QUEUE_ID

NUMBER

Queue ID

EVENT_STREAM_ID

NUMBER

Event stream ID

PRIORITY

NUMBER

Priority of the event stream partition for dequeue, range 0 - 9

EVENT_STREAM_PARTITION_ID

NUMBER

Event stream partition ID

PARTITION_ID

NUMBER

Queue partition ID

MAX_MSGS

NUMBER

Maximum number of messages for the event stream partition

ENQUEUED_MSGS

NUMBER

Number of messages enqueued for the event stream partition

MSGS_MADE_EXPIRED

NUMBER

Number of messages made expired

CHUNK_SIZE

NUMBER

The size of the memory chunk for storing messages

NUM_CHUNKS

NUMBER

Number of chunks for the event stream partition

NUM_FREE_CHUNKS

NUMBER

Number of free chunks for the event stream partition

USED_MEMORY_SIZE

NUMBER

Total estimated size of memory in use (in bytes) for the event stream partition

STATE

VARCHAR2(13)

Event stream partition state. Possible values:

• CACHED (in memory)

• UNCACHED (on disk)

• UNCACHED_FREE

• CACHED_FREE

• UNKNOWN

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