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');