Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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


See Also:

Oracle Database Advanced Queuing User's Guide for more information about Oracle Database Advanced Queueing