select s.username, s.machine, trunc(p.pga_used_mem/(1024*1024)) used_memory,
trunc(pga_alloc_mem/(1024*1024)) allocated_memory,
trunc(pga_max_mem/(1024*1024)) max_memory
from v$process p, v$session s
where p.addr = s.paddr
order by pga_max_mem desc;[@more@]
trunc(pga_alloc_mem/(1024*1024)) allocated_memory,
trunc(pga_max_mem/(1024*1024)) max_memory
from v$process p, v$session s
where p.addr = s.paddr
order by pga_max_mem desc;[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/136097/viewspace-1003869/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/136097/viewspace-1003869/
扫一扫
6145
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
