select
  b,                                       -- INST_ID NUMBER
  c,                                       -- NAME VARCHAR2(32)
  d,                                       -- BYTES NUMBER
  e                                        -- RESIZEABLE VARCHAR2(3)
from
  (
  select
    ksmsgmemidx a,
    inst_id b,
    ksmsgmemnam c,
    ksmsgmemval d,
    decode(ksmsgmemrez, 0, 'No', 1, 'Yes', NULL) e
  from
    x$ksmsgmem
union
select
  32 a,                                    -- INST_ID NUMBER
  USERENV('Instance') b,                   -- NAME VARCHAR2(32)
  'Free SGA Memory Available' c,           -- BYTES NUMBER
  current_size d,                          -- RESIZEABLE VARCHAR2(3)
  NULL e                                   -- 
from
  v$sga_dynamic_free_memory)