Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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_REGIDFoot 1  NUMBER Query cache registration ID sent by the client

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