SGA free memory
search cancel

SGA free memory


Article ID: 9882


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


The checkpoint ' SGA_Memory_Free' in the oracle probe as per probe documentation monitors 'Free SGA Memory'

Customer reports that in his environment there is SGA memory pool, its total size is around 10 GB, and they configured its thresholds 7489978368 bytes for the whole SGA memory, but they are receiving the alert for the SGA individual pools which they do not expect if refer to probe documentation.


UIM 8.31 and Aboveoracle 4.91


Use the below query which will give the output for free memory available in SGA in MB in total.

select sum(bytes)/1024/1024 " Free SGA size in MB " from v$sgastat where name!='free memory'

Additional Information