select
  inst_id,                                 -- INST_ID NUMBER
  nconam,                                  -- DB_LINK VARCHAR2(128)
  ncouid,                                  -- OWNER_ID NUMBER
  decode(                                  -- LOGGED_ON VARCHAR2(3)
    bitand(hstflg, 32), 0, 'NO', 'YES'),
  decode(                                  -- HETEROGENEOUS VARCHAR2(3)
    bitand(hstflg, 8), 0, 'NO', 'YES'),
  decode(                                  -- PROTOCOL VARCHAR2(6)
    hstpro, 1, 'V5', 2, 'V6', 3, 'V6_NLS', 4, 'V7', 'UNKN'),
  ncouct,                                  -- OPEN_CURSORS NUMBER
  decode(                                  -- IN_TRANSACTION VARCHAR2(3)
    bitand(ncoflg, 2), 0, 'NO', 'YES'),
  decode(                                  -- UPDATE_SENT VARCHAR2(3)
    bitand(ncoflg, 8), 0, 'NO', 'YES'),
  nco2pstr                                 -- COMMIT_POINT_STRENGTH NUMBER
from
  x$uganco
where
  bitand(hstflg, 1) != 0