VIEW: SYS.DBA_SCHEDULER_WINGROUP_MEMBERS

Source

View Text - Preformatted

SELECT o.name, wmo.name
  FROM obj$ o, obj$ wmo, scheduler$_wingrp_member wg,
    scheduler$_window_group w
  WHERE o.type# = 72 AND o.obj# = wg.oid AND wg.member_oid = wmo.obj#
    AND w.obj# = wg.oid AND bitand(w.flags, 8+16) = 0

View Text - HTML Formatted

SELECT O.NAME
, WMO.NAME
FROM OBJ$ O
, OBJ$ WMO
, SCHEDULER$_WINGRP_MEMBER WG
, SCHEDULER$_WINDOW_GROUP W
WHERE O.TYPE# = 72
AND O.OBJ# = WG.OID
AND WG.MEMBER_OID = WMO.OBJ#
AND W.OBJ# = WG.OID
AND BITAND(W.FLAGS
, 8+16) = 0