Oracle - What sessions are consuming resources? (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

sessions_consuming_resources.sql

select s.sid, s.username, s.osuser,
    to_char(sm.begin_time, 'HH24:MI:ss') as interval_start,
    to_char(sm.end_time, 'HH24:MI:ss') as interval_end,
    s.machine, s.process, s.program, s.module,
    sm.cpu, sm.pga_memory, sm.logical_reads, sm.physical_reads,
    sm.hard_parses, sm.soft_parses,
    s.logon_time
from v$session s, v$sessmetric sm
where sm.session_id = s.sid
and s.type = 'USER'
order by sm.cpu desc;