select
  CMON_ADDR,                               -- CMON_ADDR RAW(8)
  SESSION_ADDR,                            -- SESSION_ADDR RAW(8)
  CONNECTION_ADDR,                         -- CONNECTION_ADDR RAW(8)
  USERNAME,                                -- USERNAME VARCHAR2(1024)
  PROXY_USER,                              -- PROXY_USER VARCHAR2(1024)
  CCLASS_NAME,                             -- CCLASS_NAME VARCHAR2(1024)
  PURITY,                                  -- PURITY VARCHAR2(1024)
  TAG,                                     -- TAG VARCHAR2(1024)
  SERVICE,                                 -- SERVICE VARCHAR2(64)
  PROCESS_ID,                              -- PROCESS_ID VARCHAR2(24)
  PROGRAM,                                 -- PROGRAM VARCHAR2(64)
  MACHINE,                                 -- MACHINE VARCHAR2(64)
  TERMINAL,                                -- TERMINAL VARCHAR2(16)
  CONNECTION_MODE,                         -- CONNECTION_MODE VARCHAR2(1024)
  CONNECTION_STATUS                        -- CONNECTION_STATUS VARCHAR2(10)
from
  GV$CPOOL_CONN_INFO a
where
  a.inst_id=USERENV('Instance')