-- #############################################################################################
--
-- %Purpose: Show Users with High CPU Processing since Instance Startup
--
-- #############################################################################################
--
set feed off;
set pagesize 10000;
set wrap off;
set linesize 80;
set heading on;
set tab on;
set scan on;
set verify off;
--
spool show_users_with_high_cpu_processing.lst

ttitle 'Show Users with High CPU Processing' -
skip 2

column user_process format a10 heading "UserProcess(SID)"
column value format 999,999,999.99

select ss.username||'('||se.sid||')' user_process, value
  from v$session ss, v$sesstat se, v$statname sn
 where  se.statistic# = sn.statistic#
   and  name  like '%CPU used by this session%'
   and  se.sid = ss.sid
   and  ss.username is not null
 order  by substr(name,1,25), value desc
/
spool off;
set feed on echo off termout on pages 24 verify on
ttitle off


