7.14 V$AQ_CROSS_INSTANCE_JOBS
V$AQ_CROSS_INSTANCE_JOBS
describes each of the cross process jobs.
Each job serves to forward messages for a shard from a source instance to a destination instance for a set of subscribers of a sharded queue.
Column | Datatype | Description |
---|---|---|
|
|
Job ID within this coordinator |
|
|
Source schema of the job |
|
|
Source queue name of the cross job |
|
|
Source shard ID |
|
|
Start subshard ID of the job |
|
|
Destination instance of the cross job |
|
|
Index of the coordinator serving the job |
|
|
Process ID of the destination server |
|
|
State of the job:
|
|
|
Indicates whether the job is flow controlled:
|
|
|
Messages sent during the job |
|
|
Bytes sent during the job |
|
|
Latency for receiving ACK for the job |
|
|
Cross instance job type. Values:
|
|
|
Last priority 0 subshard received at |
|
|
Last priority 1 subshard received at |
|
|
Last priority 2 subshard received at |
|
|
Last priority 3 subshard received at |
|
|
Last priority 4 subshard received at |
|
|
Last priority 5 subshard received at |
|
|
Last priority 6 subshard received at |
|
|
Last priority 7 subshard received at |
|
|
Last priority 8 subshard received at |
|
|
Last priority 9 subshard received at |
|
|
Start time of this job |
|
|
Subscriber ID whose affinity is being switched for the |
|
|
Subscriber name whose affinity is being switched for the |
|
|
Owner instance of the shard |
|
|
Queue ID |
|
|
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