Memory Usage in AVQ
Zeigt wie viel Memory en Process oder Session brucht
select u.name, u.id, s.client_info, S.sid, s.program, s.module, s.action, s.sid, round(p.pga_used_mem / 1e6) mb
, p.pga_alloc_mem, p.pga_freeable_mem, p.pga_max_mem, p.pid, p.spid, s.event, p1, p2, p3, p1text, p2text, p3text
from v$session s, v$process p, sec_user u
where s.paddr=p.addr
-- and p.pga_used_mem > 1e9
and s.program = 'IntegrationServer.exe'
-- and osuser like '%2075%'
and to_number(S.CLIENT_INFO) = u.id
order by p.pga_alloc_mem desc;
