unix平台下使用top

windows平台下可以通过实用工具pstat.exe

获取相应进程/线程的pid.

column name format a25

column total format 999 heading 'Cnt'column bytes format 9999,999,999 heading 'Total Bytes'column avg format 99,999,999 heading 'Avg Bytes'column min format 99,999,999 heading 'Min Bytes'column max format 9999,999,999 heading 'Max Bytes'ttitle 'PGA = dedicated server processes - UGA = Client machine process'

compute sum of minmem on reportcompute sum of maxmem on reportbreak on report

 select s.username,se.sid,n.name,

 max(se.value) maxmem from v$sesstat se, v$statname n, v$session s where n.statistic# = se.statistic# and n.name in ('session pga memory','session pga memory max', 'session uga memory','session uga memory max') and s.sid = se.sid and s.username is not null and s.paddr = (SELECT addr                               FROM v$process c                               WHERE c.spid = TO_NUMBER ('&pid', 'xxxx')) group by s.username,n.name,se.sid order by 3/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6906/viewspace-21789/，如需转载，请注明出处，否则将追究法律责任。