select
  inst_id,                                 -- INST_ID NUMBER
  kswsastabsi,                             -- SERVICE_ID NUMBER
  kswsastabnm,                             -- NAME VARCHAR2(64)
  kswsastabnmh,                            -- NAME_HASH NUMBER
  kswsastabnn,                             -- NETWORK_NAME VARCHAR2(512)
  kswsastabcd,                             -- CREATION_DATE DATE
  kswsastabcdh,                            -- CREATION_DATE_HASH NUMBER
  decode(                                  -- GOAL VARCHAR2(12)
    kswsastabgoal, -1, NULL, 0, 'NONE', 1, 'SERVICE_TIME', 2, 'THROUGHPUT', NULL) kswsastabgoal,
  decode(                                  -- DTP VARCHAR2(1)
    bitand(kswsastabpflg, 2), 2, 'Y', 'N'),
  decode(                                  -- BLOCKED VARCHAR2(3)
    bitand(kswsastabgflg, 1), 1, 'YES', 'NO'),
  decode(                                  -- AQ_HA_NOTIFICATION VARCHAR2(3)
    bitand(kswsastabpflg, 4), 4, 'YES', 'NO'),
  decode(                                  -- CLB_GOAL VARCHAR2(5)
    bitand(kswsastabpflg, 8), 8, 'LONG', 'SHORT') 
from
  x$kswsastab
where
  kswsastabact = 1