Oracle: V$SGAINFO

select
   name,
-- bytes,
   resizeable
-- con_id
from
   v$sgainfo
order
   by name;
--
-- NAME                             RES
-- -------------------------------- ---
-- Buffer Cache Size                Yes
-- Data Transfer Cache Size         Yes
-- Fixed SGA Size                   No 
-- Free SGA Memory Available           
-- Granule Size                     No 
-- In-Memory Area Size              No 
-- Java Pool Size                   Yes
-- Large Pool Size                  Yes
-- Maximum SGA Size                 No 
-- Redo Buffers                     No 
-- Shared IO Pool Size              Yes
-- Shared Pool Size                 Yes
-- Startup overhead in Shared Pool  No 
-- Streams Pool Size                Yes