--

-- List Information on Consumer Groups Usage

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

SELECT name,

       consumed_cpu_time

FROM   v$rsrc_consumer_group

ORDER BY name

/