[오라클자바community]Oracel Session CPU 사용량 확인 SQL

Username - Name of the user
SID - Session id
CPU Usage - CPU centiseconds used by this session (divide by 100 to get real CPU seconds)

select        nvl(ss.USERNAME,'ORACLE PROC') username,
        se.SID,
        VALUE cpu_usage
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 desc

[출처] 오라클자바커뮤니티 - http://www.oraclejavanew.kr/bbs/board.php?bo_table=LecOrccleTun&wr_id=27