-- name       : free_memory.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: This script displays the free memory
-- limitation : needs access to v$sgastat
--
-- useage     : SQL> @free_memory

set pages 50
set feed off
set verify off
set linesize 80

spool free_memory.lis

col bytes head "Size (MB)" for 999,999,999
col name head "Name" for a40

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

spool off

set pages 24
set feed on
set verify on
set lines 80