— chk_pga_mem.sql
select substr(name,1,40) param_name,value/1024 value_mb
from v$pgastat
where name in ( ‘total PGA allocated’,’maximum PGA allocated’
,’PGA memory freed back to OS’,’bytes processed’)
union
select substr(name,1,40) param_name,value value_mb
from v$pgastat
where name in ( ‘process count’)
/