--

-- List Consumer Groups

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SELECT consumer_group,

       status,

       comments

FROM   dba_rsrc_consumer_groups

ORDER BY consumer_group

/