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_SERVER_POOL

V$AQ_SERVER_POOL lists performance statistics for all the servers in the pool.

Column Datatype Description
COORDINATOR_ID NUMBER ID of the coordinator
COORDINATOR_INSTANCE_ID NUMBER Instance of the coordinator
PROCESS_ID VARCHAR2(24) Operating system process ID of the server
PROCESS_NAME VARCHAR2(48) Operating system process name of the server
JOB_NAME VARCHAR2(32) Name of the job handled
POOL_STATE VARCHAR2(20) State of the pool:
  • REMOTE

  • IDLE

  • ACTIVE

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