Current SGA usage - Oracle Database Script. SELECT round(used.bytes /1024/1024, 2) used_mb, round(free.bytes /1024/1024, 2) free_mb, round(tot.bytes /1024/1024, 2) total_mb FROM (SELECT sum(bytes) bytes FROM v$sgastat WHERE name != 'free memory') used , (SELECT sum(bytes) bytes FROM v$sgastat WHERE name = 'free memory') FREE, (SELECT sum(bytes) bytes FROM v$sgastat) tot /
SELECT round(used.bytes /1024/1024, 2) used_mb, round(free.bytes /1024/1024, 2) free_mb, round(tot.bytes /1024/1024, 2) total_mb FROM (SELECT sum(bytes) bytes FROM v$sgastat WHERE name != 'free memory') used , (SELECT sum(bytes) bytes FROM v$sgastat WHERE name = 'free memory') FREE, (SELECT sum(bytes) bytes FROM v$sgastat) tot /