Check Shared Pool Free Memory

by

Here we will learn how to check shared pool free status, need to execute below SQL’s.

To check shared pool free memory only.

SQL>SELECT INST_ID, POOL, NAME, BYTES/1024/1024 "SPACE MB"
        FROM gv$sgastat WHERE name = 'free memory' AND POOL = 'shared pool'
        ORDER BY INST_ID;

SQL> SELECT * FROM v$sgastat WHERE name = 'free memory';

To check sga component utilization status.

SQL>select *from v$sgastat;

To check history of free shared pool free memory.

SQL>select to_char( dhs.begin_interval_time,'YYYY_MM_DD HH24:MI') time,
dhs.instance_number,
dhss.name,
dhss.bytes
from dba_hist_sgastat dhss, dba_hist_snapshot dhs
where dhss.pool = 'shared pool'
and dhss.name = 'free memory'
AND dhss.snap_id = dhs.snap_id
AND dhss.instance_number = dhs.instance_number
order by dhs.begin_interval_time desc;

Leave a Comment