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;