Oracle教程

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 官方解释，作用，如何使用详细说明
分享到：

相关推荐