VIEW: SYS.DBA_RSRC_GROUP_MAPPINGS

Source

View Text - Preformatted

select m.attribute, m.value, m.consumer_group,
       decode(m.status,'PENDING',m.status, NULL)
from sys.resource_group_mapping$ m
order by m.status,
         (select p.priority from sys.resource_mapping_priority$ p
          where m.status = p.status and m.attribute = p.attribute),
         m.consumer_group, m.value

View Text - HTML Formatted

SELECT M.ATTRIBUTE
, M.VALUE
, M.CONSUMER_GROUP
, DECODE(M.STATUS
, 'PENDING'
, M.STATUS
, NULL) FROM SYS.RESOURCE_GROUP_MAPPING$ M ORDER BY M.STATUS
, (SELECT P.PRIORITY
FROM SYS.RESOURCE_MAPPING_PRIORITY$ P
WHERE M.STATUS = P.STATUS
AND M.ATTRIBUTE = P.ATTRIBUTE)
, M.CONSUMER_GROUP
, M.VALUE