Search notes:

Oracle: V$LATCH_CHILDREN

v$latch_children records statistics about (child-) latches.
select
   count(*),
   name
from
   v$latch_children
where
   gets > 0
group by
   name
order by
   count(*) desc;

Joining v$latch_children to x$bh

In the case of v$latch_children.name = 'cache buffer chains', addr can be joined to hladdr of x$bh.

See also

v$latch, v$latch vs v$latch_parent vs v$latch_children
Oracle Dynamic Performance Views

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...', 1758205634, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/dynamic-performance-views/latch/children/index(57): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78