DBA_RSRC_GROUP_MAPPINGS

DBA_RSRC_GROUP_MAPPINGS displays the mapping between session attributes and consumer groups in the database.

Column Datatype NULL Description
ATTRIBUTE VARCHAR2(30)   Session attribute to match
VALUE VARCHAR2(128)   Attribute value
CONSUMER_GROUP VARCHAR2(30)   Target consumer group name
STATUS VARCHAR2(30)   PENDING, if consumer group is part of the pending area; NULL otherwise.