SELECT substr(a.sid,1,5) "Sid",
substr(a.process,1,7) "Process",
nvl(a.USERNAME,'ORACLE PROC') "user",
v.value "CPU used by this session"
FROM v$statname s, v$sesstat v, v$session a
WHERE s.name = 'CPU used by this session'
and v.statistic#=s.statistic#
AND v.sid = a.sid
and v.value > 0
ORDER BY v.value DESC;
substr(a.process,1,7) "Process",
nvl(a.USERNAME,'ORACLE PROC') "user",
v.value "CPU used by this session"
FROM v$statname s, v$sesstat v, v$session a
WHERE s.name = 'CPU used by this session'
and v.statistic#=s.statistic#
AND v.sid = a.sid
and v.value > 0
ORDER BY v.value DESC;
Comments