select
  name,                                    -- NAME VARCHAR2(32)
  bytes,                                   -- BYTES NUMBER
  resizeable                               -- RESIZEABLE VARCHAR2(3)
from
  gv$sgainfo
where
  inst_id = USERENV('Instance')