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