SGA free memory

Document ID : KB000009882
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

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

Background:

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
Instructions:

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: