PGA для неактивных сессий:
Код:
select sum(ROUND(s.value/1024)) || ' KB' as pga_memory_usage_inactive from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status='INACTIVE' and type= 'USER' and username='XXXXXXXXXXXXXXXX') and n.name = 'session pga memory' group by name;
PGA для всех сессий:
Код:
select sum(ROUND(s.value/1024)) || ' KB' as pga_memory_usage_total from v$sesstat s , v$statname n where s.statistic# = n.statistic# and n.name = 'session pga memory' group by name;
UGA для неактивных сессий:
Код:
select sum(ROUND(s.value/1024)) || ' KB' as uga_memory_usage_inactive from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status='INACTIVE' and type= 'USER' and username='XXXXXXXXXXXXXXXX') and n.name = 'session uga memory' group by name;
UGA для всех сессий:
Код:
select sum(ROUND(s.value/1024)) || ' KB' as uga_memory_usage_total from v$sesstat s , v$statname n where s.statistic# = n.statistic# and n.name = 'session uga memory' group by name;
Сколько использует памяти конкретная неактивная сессия:
Код:
select TO_CHAR(ROUND(s.value/1024),99999999) || ' KB' as Memory_Usage , n.name|| '('||s.statistic#||')' as memory_type , sid from v$sesstat s , v$statname n where s.statistic# = n.statistic# and sid in (select sid from v$session where status='INACTIVE' and type= 'USER' and username='XXXXXXXXXXXXXXXX') and n.name like '%ga memory%' order by value;