V$AQ_BMAP_NONDUR_SUBSCRIBERS
V$AQ_BMAP_NONDUR_SUBSCRIBERS can be used to get the available bit positions. The view is queried to get the free bit position during creation of a non-durable subscriber.
| Column | Datatype | Description |
|---|---|---|
QUEUE_ID |
NUMBER |
Queue ID |
USED_POS |
RAW(128) |
Stream of bits to identify used and available bit positions |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|
See Also: Oracle AI Database Transactional Event Queues and Advanced Queuing User’s Guide for more information about Oracle Database Advanced Queueing