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