V$AQ_SUBSCRIBER_LOAD describes the load of all subscribers of sharded queues in terms of latency at every instance in an Oracle RAC environment. Latency denotes the predicted amount of time (in seconds) required from the current time to drain all the messages for that subscriber at each respective instance. The latency calculation considers past enqueue/dequeue rates and future enqueue/dequeue rates based on history.
FINITE - The subscriber will be able to dequeue all the messages in a finite amount of time
INFINITE - The subscriber's dequeue rate may not catch up to the enqueue rate
UNKNOWN - Latency is not yet known
Latency (in seconds). Valid only when LATENCY_STATE is FINITE.
Approximate number of dequeue requests noted recently
Number of queue shards that have messages for this subscriber
Indicates whether the subscriber is actively listening at this instance for messages (TRUE) or not (FALSE)
For internal use only
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