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`	`NUMBER`	Job ID within this coordinator
`SCHEMA_NAME`	`VARCHAR2(30)`	Source schema of the job
`QUEUE_NAME`	`VARCHAR2(30)`	Source queue name of the cross job
`SHARD_ID`	`NUMBER`	Source shard ID
`START_SUBSHARD_ID`	`NUMBER`	Start subshard ID of the job
`DESTINATION_INSTANCE_ID`	`NUMBER`	Destination instance of the cross job
`COORDINATOR_ID`	`NUMBER`	Index of the coordinator serving the job
`DEST_SERVER_PROCESS_ID`	`NUMBER`	Process ID of the destination server
`JOB_STATE`	`VARCHAR2(9)`	State of the job: `REQUESTED` `RUNNING` `STOPPED` `PAUSED` `CRASHED` `INACTIVE`
`FLOW_CONTROL`	`NUMBER`	Indicates whether the job is flow controlled: `0` - The job is not flow controlled `1` - The job is flow controlled
`MSGS_SENT`	`NUMBER`	Messages sent during the job
`BYTES_SENT`	`NUMBER`	Bytes sent during the job
`ACK_LATENCY`	`NUMBER`	Latency for receiving ACK for the job
`CON_ID`	`NUMBER`	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