Oracle Database – use below query to find the sessions using a lot of CPU
col program form a30 heading „Program“
col CPUMins form 99990 heading „CPU in Mins“
select rownum as rank, a.*
from (
SELECT v.sid, program, v.value / (100 * 60) CPUMins
FROM v$statname s , v$sesstat v, v$session sess
WHERE s.name = ‚CPU used by this session‘
and sess.sid = v.sid
and v.statistic#=s.statistic#
and v.value>0
ORDER BY v.value DESC) a
where rownum < 11;
This entry was posted on Montag, März 14th, 2022 at 12:04 and is filed under Administration, ORACLE Database. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.