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