V$PROCESS_POOL provides information about process pools.
Indicates whether the pool is active (TRUE) or not (FALSE)
The default or configured minimum value
The default or configured batch count
The default or configured initial count
The number of spawned processes available in this pool
When INIT_COUNT is set, MAX_COUNT shows the number of processes yet to be spawned. Note that the current process count (CUR_COUNT) cannot reach INIT_COUNT in cases where processes are consumed during the spawn.
The ID of the container to which the data pertains. Possible values include:
0: This row 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
This view is available starting with Oracle Database 12c Release 2 (220.127.116.11).