Search notes:

Oracle: X$KSMGE

x$ksmge lists memory granules: sizes, start address, states (allocated, free, invalid…)?
select
   gran.baseaddr,
   gran.granstate,
   type.component /*,
   type.parno,
   type.cursize,
   type.usersize,
   type.initsize,
   type.targsize,
   type.minsize,
   type.maxsize,
   type.opercnt,
   type.lastoper,
   type.lastmode,
   type.lasttime,
   type.starttime,
   type.laststat,
   type.lastopstatus,
   type.lastopts */
from
   x$ksmge  gran                                      left join
   x$kmgsct type on gran.grantype = type.grantype;
select
   to_number(baseaddr, 'xxxxxxxxxxxxxxxx') addr,
  (to_number(baseaddr, 'xxxxxxxxxxxxxxxx') - lag(to_number(baseaddr, 'xxxxxxxxxxxxxxxx')) over (order by baseaddr)) / 1024 diff_prev,
   gransize/1024
from
   x$ksmge;

See also

Granules

Index