V$AUTHPOOL_STATS

V$AUTHPOOL_STATS displays statistics for the authentication pool. This pool authenticates user connections when client applications connect to Database Resident Connection Pooling (DRCP).

Column Datatype Description
NUM_SRVS NUMBER Total number of servers in the authentication pool
NUM_BUSY NUMBER Number of busy servers in the authentication pool
NUM_FREE NUMBER Number of free servers in the authentication pool
NUM_WAITERS NUMBER Number of connections waiting for a server in the authentication pool to become available
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 multitenant container database (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