VIEW: SYS.DBA_SCHEDULER_GROUP_MEMBERS

Source

View Text - Preformatted

SELECT wgm.owner, wgm.group_name,wgm.cred || wgm.mem_name
FROM
(SELECT u.name owner, o.name group_name, wg.member_oid2 member_oid2,
        decode(member_oid2, null,null,'"' || cmu.name || '"."' || cmo.name || '"@') cred,
        decode(wmu.name || '"' || substr(wmo.name,1,12), 'SYS"SCHED$_LOCAL', 'LOCAL',
          '"'  || wmu.name || '"."' || wmo.name || '"' )mem_name
FROM user$ u, obj$ o, scheduler$_window_group w, scheduler$_wingrp_member wg,
     user$ wmu, obj$ wmo, user$ cmu, obj$ cmo
WHERE w.obj# = wg.oid AND w.obj# = o.obj# AND o.owner# = u.user# AND
  wg.member_oid = wmo.obj# AND wmo.owner# = wmu.user# AND
  cmo.obj#(+) = wg.member_oid2 AND cmo.owner# = cmu.user#(+) )wgm

View Text - HTML Formatted

SELECT WGM.OWNER
, WGM.GROUP_NAME
, WGM.CRED || WGM.MEM_NAME FROM (SELECT U.NAME OWNER
, O.NAME GROUP_NAME
, WG.MEMBER_OID2 MEMBER_OID2
, DECODE(MEMBER_OID2
, NULL
, NULL
, '"' || CMU.NAME || '"."' || CMO.NAME || '"@') CRED
, DECODE(WMU.NAME || '"' || SUBSTR(WMO.NAME
, 1
, 12)
, 'SYS"SCHED$_LOCAL'
, 'LOCAL'
, '"' || WMU.NAME || '"."' || WMO.NAME || '"' )MEM_NAME FROM USER$ U
, OBJ$ O
, SCHEDULER$_WINDOW_GROUP W
, SCHEDULER$_WINGRP_MEMBER WG
, USER$ WMU
, OBJ$ WMO
, USER$ CMU
, OBJ$ CMO WHERE W.OBJ# = WG.OID
AND W.OBJ# = O.OBJ#
AND O.OWNER# = U.USER# AND WG.MEMBER_OID = WMO.OBJ#
AND WMO.OWNER# = WMU.USER# AND CMO.OBJ#(+) = WG.MEMBER_OID2
AND CMO.OWNER# = CMU.USER#(+) )WGM