script consume memory

proses yg meng-consume memory :

select program, pga_alloc_mem from v$process order by 2 desc;

script free memory

SELECT pool, name, ROUND(bytes/1024, 2) "Kbytes" FROM v$sgastat

WHERE LOWER(pool) = 'large pool' AND LOWER(name) IN ('free memory');



SELECT pool, name, ROUND(bytes/1024, 2) "Kbytes" FROM v$sgastat

WHERE LOWER(pool) = 'shared pool' AND LOWER(name) IN ('free memory');



SELECT pool, name, ROUND(bytes/1024, 2) "Kbytes" FROM v$sgastat

WHERE LOWER(pool) = 'java pool' AND LOWER(name) IN ('free memory');