-- Description
-- This script lists the CPU consumed and the Consumer Group a session is using 
-- when the Database Resource Manager has been enabled.

col sid form 99 heading "SID"
col serial# form 9999 heading "Serial"
col program form a50 heading "Program"
col username form a12 heading "Username"
col resource_consumer_group form a22 heading "Consumer Group"
col name form a12 heading "Name"
col active_sessions form 99999 head "Active"
col consumed_cpu_time form 99999999 heading "Con CPU"
col SESSIONS_QUEUED form 99999 heading "Queued" 

-- spool monrsrc.lst

select sid,serial#,username,program,resource_consumer_group 
from v$session
/

select name,active_sessions,consumed_cpu_time
       ,requests,cpu_wait_time,cpu_waits, SESSIONS_QUEUED
from v$rsrc_consumer_group
/

-- spool off