select
a.SID, c.serial#, c.username, c.osuser, c.MODULE, c.status, d.spid AS
"PROCESS_ID", DECODE(c.username, NULL, 0, c.last_call_et) AS
"SCNDS_IDLE", ((SYSDATE - c.logon_time) * 60 * 60 * 24) AS
"SCNDS_SINCE_LOGON", trunc(a.VALUE / 100) AS cpu_usage
FROM
v$sesstat a, v$sysstat b, v$session c, v$process d WHERE
c.SID = a.SID AND c.paddr(+) = d.addr AND
a.statistic# = b.statistic# AND b.NAME = 'CPU used by this session'
ORDER BY c.status ASC, a.VALUE DESC;
CPU used by this session
最新推荐文章于 2022-07-09 17:46:22 发布