Oracle教程 2023-04-04

Oracle 视图 V$CPOOL_CONN_INFO 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$CPOOL_CONN_INFO用于监视连接池信息，并可用于了解回收进程的运作情况。

此视图具有下列字段：

• CP_CON_ID ：已从连接池中分配的连接ID
• CP_NEX_TIME ：连接上次使用的时间
• CP_CHECK_TIME ：连接应检查的时间
• CP_USE_COUNT ：使用此连接的次数
• CP_LAST_EVENT ：最近发生的事件
• CP_VALID ：此连接有效性
• CP_ANY_USER ：此连接是否可用于任意用户

V$CPOOL_CONN_INFO视图可以帮助确定生存期内连接状态，以了解从连接池中分配什么连接。

可以使用以下语法查询V$CPOOL_CONN_INFO视图：

SELECT *
FROM V$CPOOL_CONN_INFO;

官方英文解释

V$CPOOL_CONN_INFO displays connection information about each connection to the connection broker.

Column	Datatype	Description
`CMON_ADDR`	`RAW(4 \| 8)`	Address of the connection broker
`SESSION_ADDR`	`RAW(4 \| 8)`	Address of the session associated with the connection; NULL if the connection does not have an associated session
`CONNECTION_ADDR`	`RAW(4 \| 8)`	Address of the connection
`USERNAME`	`VARCHAR2(1024)`	Name of the user associated with the connection
`PROXY_USER`	`VARCHAR2(1024)`	Name of the proxy user
`CCLASS_NAME`	`VARCHAR2(1024)`	Connection class associated with the connection
`PURITY`	`VARCHAR2(1024)`	Purity used to create the connection (can be `SELF` or `NEW`)
`TAG`	`VARCHAR2(1024)`	Tag, if specified, at connection creation time
`SERVICE`	`VARCHAR2(64)`	TNS service name for the connection
`PROCESS_ID`	`VARCHAR2(24)`	Client process ID of the process which created the connection
`PROGRAM`	`VARCHAR2(84)`	Program name of the client process which created the connection
`MACHINE`	`VARCHAR2(64)`	Machine name of the client process which created the connection
`TERMINAL`	`VARCHAR2(30)`	Terminal identifier of the client process which created the connection
`CONNECTION_MODE`	`VARCHAR2(1024)`	Reserved for internal use
`CONNECTION_STATUS`	`VARCHAR2(10)`	Status of the connection: `NONE` `CONNECTING` `ACTIVE`: A pooled server has been mapped to this connection. `WAITING`: The connection is waiting for a pooled server based on the client request. `IDLE`: No pooled server has been mapped to this connection and there is no request to map one. `CLOSING`
`CLIENT_REGID`	`NUMBER`	Query cache registration ID sent by the client
`CURSTATUS_TIME`	`NUMBER`	Time in microseconds spent in the current state. See `CONNECTION_STATUS` above.
`IDLE_TIME`	`NUMBER`	Total time in `IDLE` state for the connection (in microseconds)
`ACTIVE_TIME`	`NUMBER`	Total time in `ACTIVE` state for the connection (in microseconds)
`WAIT_TIME`	`NUMBER`	Total time in `WAITING` state for the connection (in microseconds)
`THINK_TIME`	`NUMBER`	Total think time for the connection assigned to the pooled server, but not doing any database activity (in microseconds)
`LAST_IDLE_TIME`	`NUMBER`	Time in last `IDLE` state for this connection (in microseconds)
`LAST_ACTIVE_TIME`	`NUMBER`	Time in last `ACTIVE` state for this connection (in microseconds)
`LAST_WAIT_TIME`	`NUMBER`	Time in last `WAITING` state for this connection (in microseconds)
`LAST_THINK_TIME`	`NUMBER`	Time for the connection assigned to the pooled server, but not doing any database activity during the last `ACTIVE` state (in microseconds)
`NUMGETS`	`NUMBER`	Total number of requests at the connection level
`NUMHITS`	`NUMBER`	Total number of hits at the connection level
`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

数据运维技术 » Oracle 视图 V$CPOOL_CONN_INFO 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐