GV$ACTIVE_SERVICES

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
home |  up  |  mailbox