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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759428179, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/architecture/instance/fixed-tables/k/s/m/ge/index(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78