1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$IM_COLUMN_LEVEL to V$RULE_SET_AGGREGATE_STATS
  4. V$PROCESS_POOL

8.129 V$PROCESS_POOL

V$PROCESS_POOL provides information about process pools.

Column Datatype Description

POOL_NAME

VARCHAR2(512)

Pool name

ENABLED

VARCHAR2(5)

Indicates whether the pool is active (TRUE) or not (FALSE)

MIN_COUNT

NUMBER

The default or configured minimum value

BATCH_COUNT

NUMBER

The default or configured batch count

INIT_COUNT

NUMBER

The default or configured initial count

CUR_COUNT

NUMBER

The number of spawned processes available in this pool

MAX_COUNT

NUMBER

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.

CON_ID

NUMBER

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