GV$SGAINFO
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, USERENV ('Instance') b, 'Free SGA Memory Available' c, current_size d, NULL e from v$sga_dynamic_free_memory)

home |  up  |  mailbox