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.