7.23 V$AQ_NONDUR_SUBSCRIBER_LWM
V$AQ_NONDUR_SUBSCRIBER_LWM
projects the low watermarks (LWMs) of non-durable subscribers in a sharded queue. The LWM of a non-durable subscriber is a combination of shard, priority and LWM (subshard).
Column | Datatype | Description |
---|---|---|
|
|
Queue ID |
|
|
ID of the non-durable subscriber |
|
|
Shard ID |
|
|
Priority of the shard |
|
|
Lower watermark (in a subshard) of the non-durable subscriber |
|
|
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