viernes, 7 de febrero de 2014

Identifying High CPU Users



Listing . Identifying High CPU Users

SELECT n.username,  s.sid,  s.value  FROM v$sesstat s, v$statname t, v$session n
WHERE s.statistic# = t.statistic#
AND n.sid = s.sid
AND t.name='CPU used by this session'
ORDER BY s.value desc;