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;
Index