GV$SGA_DYNAMIC_FREE_MEMORY definition in Oracle Database 11.2
GV$SGA_DYNAMIC_FREE_MEMORY

select
  inst_id,                                 -- INST_ID NUMBER
  gv.gransize * (                          -- CURRENT_SIZE NUMBER
  select
    count(*)
  from
    x$ksmge
  where
    granstate = 'FREE' or granstate = 'INVALID')
from
  x$kmgsct gv
where
  rownum=1

home |  up