Hi all,

You can find SGA and PGA current usage with these queries:

SGA Current Usage
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;

PGA Current Usage
SELECT ROUND(SUM(PGA_MAX_MEM)/(1024*1024),2) "PGA CURRENT USAGE (MB)" 
FROM V$PROCESS;

See you later.

Oracle

PGASGAUSAGE