dba_rsrc_categories shows all all resource consumer group categories.
column name format a14
column comments format a38
column mandatory format a3
column status format a4
select
name,
comments,
mandatory,
status
from
dba_rsrc_categories;
--
-- NAME COMMENTS MAN STAT
-- -------------- -------------------------------------- --- ----
-- ADMINISTRATIVE Administrative Consumer Groups NO
-- INTERACTIVE Interactive, OLTP Consumer Groups NO
-- BATCH Batch, Non-Interactive Consumer Groups NO
-- MAINTENANCE Maintenance Consumer Groups NO
-- OTHER Unclassified Consumer Groups YES