https://docs.oracle.com/en/database/oracle/oracle-database/26/refrn/DBA_RSRC_CONSUMER_GROUPS.html
DBA_RSRC_CONSUMER_GROUPS displays information about all resource consumer groups in the database.
consumer groupsdbarsrc
https://docs.oracle.com/en/database/oracle/oracle-database/26/refrn/DBA_RSRC_GROUP_MAPPINGS.html
DBA_RSRC_GROUP_MAPPINGS displays the mapping between session attributes and consumer groups in the database.
dbarsrcgroupmappings
https://docs.oracle.com/en/database/oracle/oracle-database/26/refrn/V-RSRC_PDB.html
V$RSRC_PDB displays data related to currently active resource consumer groups by pluggable database (PDB).
vrsrcpdb
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-RSRC_PLAN_CPU_MTH.html
V$RSRC_PLAN_CPU_MTH displays all available CPU resource allocation methods defined for resource plans.
vrsrcplancpumth
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_RSRC_PLANS.html
DBA_RSRC_PLANS displays information about all resource plans in the database.
dbarsrcplans
https://docs.oracle.com/cd/E16338_01/server.112/b56311/dynviews_2159.htm
vrsrcplan
https://docs.oracle.com/en/database/oracle/oracle-database/26/refrn/V-RSRC_SESSION_INFO.html
V$RSRC_SESSION_INFO displays Resource Manager statistics per session.
session infovrsrc