Mem Usage

				
					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;