Oracle 세션별 Resource 사용량 확인

Oracle 세션별 Resource 사용량 확인 

SID - Session ID
Username - Name of the user
Statistic - Name of the statistic
Value - Current value

select        ses.SID,
        nvl(ses.USERNAME,'ORACLE PROC') username,
        sn.NAME statistic,
        sest.VALUE
from        v$session ses,
        v$statname sn,
        v$sesstat sest
where        ses.SID = sest.SID
and        sn.STATISTIC# = sest.STATISTIC#
and        sest.VALUE is not null
and        sest.VALUE != 0           
order        by ses.USERNAME, ses.SID, sn.NAME

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