SQL Script Free Memory for SGA

Updated: 30-Jun-2002
Version: 1.0

Description

This script list the total memory in the shared_pool and the amount of free memory. (Remember: too much free memory in the shared_pool is wasteful and may be better used elsewhere !)

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

col value form 999,999,999,999 heading "Shared Pool Size"
col bytes form 999,999,999,999 heading "Free Bytes"
col percentfree form 999 heading "Percent Free"

spool freesga.lst

select   to_number(v$parameter.value) value, v$sgastat.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 

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links