SET FEED OFF
SET ECHO OFF
PROMPT
PROMPT EXISTING SGA SIZE
PROMPT
COL VALUE FORM 999,999,999 HEADING "SHARED POOL SIZE "
COL BYTES  FORM 999,999,999 HEADING "FREE BYTES "
COL PERCENTFREE FORM 999,999,999,999 HEADING "PERCENT FREE"
SPOOL FREESGA.LST
SELECT TO_NUMBER(V$PARAMETER.VALUE) VALUE,
V$SGASTAT.BYTES BYTES,
(V$SGASTAT.BYTES/V$PARAMETER.VALUE)*100 PERCENTFREE
FROM V$SGASTAT,V$PARAMETER
WHERE V$SGASTAT.NAME = 'free memory'
and v$PARAMETER.NAME = 'shared_pool_size';
spool off
SET FEED ON
Hosted by www.Geocities.ws

1