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’;