10.123 V$TDM_STATS

V$TDM_STATS describes statistics for Oracle Connection Manager in Traffic Director Mode (CMAN-TDM).

Column	Datatype	Description
CMAN_ID	VARCHAR2(1024)	CMAN-TDM host name
GATEWAY_ID	NUMBER	Index of the gateway process of CMAN-TDM
SERVICE_NAME	VARCHAR2(1024)	Reserved for future use
PRCP_NUM_REQUESTS	NUMBER	Number of client requests that resulted in acquire on the Proxy Resident Connection Pool (PRCP)
PRCP_NUM_BUSY_CONNECTIONS	NUMBER	Number of busy server connections in the PRCP
PRCP_NUM_OPEN_CONNECTIONS	NUMBER	Number of busy and free server connections in the PRCP
PRCP_HISTORIC_MAX_CONNECTIONS	NUMBER	Maximum size (number of connections) that the PRCP has ever reached
PRCP_NUM_WAITS	NUMBER	Total number of client requests that waited due to unavailability of free server connections in the PRCP This value accumulates since the start of the process.
PRCP_NUM_WAITS_ACTIVE	NUMBER	Number of active client requests currently waiting due to unavailability of free server connections in the PRCP
PRCP_NUM_HITS	NUMBER	Total number of times that client requests found matches in the PRCP
PRCP_NUM_INBOUND_CONNECTIONS	NUMBER	Total Number of active client connections for the PRCP
EDITION	VARCHAR2(1024)	Database edition name associated with the PRCP
UPDATED_TIME	TIMESTAMP(6) WITH TIME ZONE	Date and time at which the statistics were uploaded to the PDB
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 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

Note:

This view is available starting with Oracle Database 23ai.