-- name       : sga_mem.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show details of the sga memory
-- limitation : needs access to x$ksmsp
--
-- useage     : SQL> @sga_mem

set pages 50
set feed off
set verify off
set linesize 200

spool sga.lis

col ksmchcom head "Type" for a30
col ksmchcls head "Status" for a10
col ksmchsiz head "Size" for 999,999,999

select 	ksmchcom,
	ksmchcls,
	ksmchsiz
from 	x$ksmsp
/

spool off

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