SGA free memory
Article ID: 9882
Updated On:
Products
DX Unified Infrastructure Management (Nimsoft / UIM)
Issue/Introduction
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.
Environment
UIM 8.31 and Aboveoracle 4.91
Resolution
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
Feedback
Yes
No
Powered by
