Database Resource Manager Information

View Name	Information
DBA_RSRC_PLANS	Plans and status
DBA_RSRC_PLAN_DIRECTIVES	Plan directives
DBA_RSRC_CONSUMER_GROUPS	Consumer groups
DBA_RSRC_CONSUMER_GROUPS_PRIVS	Users/roles
DBA_RSRC_GROUP_MAPPINGS	Consumer group mapping
DBA_RSRC_MAPPING_PRIORITY	Mapping priority
DBA_USERS	Column initial_rsrc_consumer_group
DBA_RSRC_MANAGER_SYSTEM_PRIVS	Users/roles

   

SQL> show parameter resource_manager_plan

   

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

resource_manager_plan string INTERNAL_PLAN