7.19 V$AQ_MESSAGE_CACHE
V$AQ_MESSAGE_CACHE
provides performance statistics of the message cache for sharded queues at the subshard level in the instance.
Column | Datatype | Description |
---|---|---|
|
|
Queue ID |
|
|
Shard ID |
|
|
Priority of the subshard for dequeue, range |
|
|
Subshard ID in the shard |
|
|
Partition id for the particular subshard |
|
|
Maximum number of messages of subshard |
|
|
Number of messages enqueued for the subshard |
|
|
Number of messages made expired |
|
|
The size of the memory chunk for storing messages |
|
|
Number of chunks for the subshard |
|
|
Number of free chunks for the subshard |
|
|
Total estimated size of memory in use (in bytes) for the subshard |
|
|
Subshard state. Possible values:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database Advanced Queuing User's Guide for more information about Oracle Database Advanced Queueing