8.151 V$CPOOL_CONN_INFO
V$CPOOL_CONN_INFO
displays connection information about each connection to the connection broker.
Column | Datatype | Description |
---|---|---|
|
|
Address of the connection broker |
|
|
Address of the session associated with the connection; NULL if the connection does not have an associated session |
|
|
Address of the connection |
|
|
Name of the Database Resident Connection Pool |
|
|
Name of the user associated with the connection |
|
|
Name of the proxy user |
|
|
Connection class associated with the connection |
|
|
Purity used to create the connection (can be |
|
|
Tag, if specified, at connection creation time |
|
|
TNS service name for the connection |
|
|
Client process ID of the process which created the connection |
|
|
Program name of the client process which created the connection |
|
|
Machine name of the client process which created the connection |
|
|
Terminal identifier of the client process which created the connection |
|
|
Reserved for internal use |
|
|
Status of the connection:
|
|
|
Query cache registration ID sent by the client |
|
|
Time in microseconds spent in the current state. See |
|
|
Total time in |
|
|
Total time in |
|
|
Total time in |
|
|
Total think time for the connection assigned to the pooled server, but not doing any database activity (in microseconds) |
|
|
Time in last |
|
|
Time in last |
|
|
Time in last |
|
|
Time for the connection assigned to the pooled server, but not doing any database activity during the last |
|
|
Total number of requests at the connection level |
|
|
Total number of hits at the connection level |
|
|
The ID of the container to which the data pertains. Possible values include:
|