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

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

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


V$AQ_JOB_COORDINATOR lists performance statistics per coordinator, for every AQ coordinator controlled by the Oracle Database Advanced Queueing master coordinator.

Column Datatype Description
COORDINATOR_ID NUMBER ID of the coordinator
PROCESS_ID VARCHAR2(24) Operating system process ID of the coordinator
PROCESS_NAME VARCHAR2(48) Operating system process name of the coordinator
JOB_NAME VARCHAR2(32) Name of the job handled
JOB_TYPE NUMBER Type of job handled
SERVER_COUNT NUMBER Number of servers active
MAX_SERVER_COUNT NUMBER Maximum server fanout achieved
CON_ID NUMBER The ID of the container to which the data pertains. The CON_ID value in this view is always 0. The rows pertain to the entire CDB or to the non-CDB.

See Also:

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