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(48)`	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` `WAITING` `IDLE` `CLOSING`
`CLIENT_REGID`^Foot 1	`NUMBER`	Query cache registration ID sent by the client

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).