Doc

    Name:  sesscpu.sql

    Author Mark Gurry

    This script shows the amount of CPU that each user has 
    consumed. You must have TIMED_STATISTICS set to TRUE!


#


ttitle ' CPU Used By Session Information '
select substr(name,1,30) parameter,
			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
 order  by value, substr(name,1,25) desc;