REM  #*****************************************************
REM  # File Name: free_memory.sql
REM  #
REM  # Purpose: Reports the shared pool free memory
REM  #
REM  #*****************************************************


column bytes format 999,999,999
select name,bytes/1024/1024
from v$sgastat where name='free memory';