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.