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