7.27 V$AQ_REMOTE_DEQUEUE_AFFINITY
V$AQ_REMOTE_DEQUEUE_AFFINITY
lists the dequeue affinity instance of the subscribers not dequeuing locally from the shard's owner instance. Cross instance message forwarding is used for these subscribers.
Column | Datatype | Description |
---|---|---|
|
|
Queue ID |
|
|
Shard ID which is being forwarded from SOURCE_INSTANCE to INST_ID for the subscriber |
|
|
Owner instance ID from where the shard is being forwarded |
|
|
Subscriber ID |
|
|
Queue schema name |
|
|
Queue name |
|
|
The ID of the container to which the data pertains. Possible values include:
|