Sql to get Shared Pool size

select  pool, 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 pool=’shared pool’
and v$parameter.name = ’shared_pool_size’;

Leave a Reply