select ss.sid,
vs.SERIAL#,
decode(vs.USERNAME, '', 'BK Process', vs.USERNAME) username,
vs.OSUSER,
vs.TERMINAL,
vs.PROGRAM,
sum(case
when st.NAME = 'CPU used by this session' then
ss.VALUE
END) "CPU",
sum(case
when st.NAME = 'session pga memory' then
ss.VALUE
END) "Memory-PGA",
sum(case
when st.NAME = 'physical reads' then
ss.VALUE
END) "I/O Phys Reads",
sum(case
when st.NAME = 'session logical reads' then
ss.VALUE
END) "LOG Reads",
sum(case
when st.NAME = 'parse count (hard)' then
ss.VALUE
END) "Hard Parse"
from v$sesstat ss, v$statname st, v$session vs
where ss.STATISTIC# = st.STATISTIC#
and vs.SID = ss.SID
group by ss.sid,
vs.SERIAL#,
vs.USERNAME,
vs.OSUSER,
vs.TERMINAL,
vs.PROGRAM
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29987/viewspace-51956/ ，如需转载，请注明出处，否则将追究法律责任。
