Oracle: X$KSLLW

select
   count(*) over () cnt,
   ws.ksllasnam "parent name"  ,
   lw.ksllwnam  "location"     , -- Kernel function name
   lw.ksllwlbl  "unit to guard",
   ws.indx
from
   x$ksllw  lw                        join
   x$kslwsc ws on lw .indx = ws.indx
-- where
--     lw.ksllwnam like 'kcbgtcr%'                  and
--     ws.ksllasnam      = 'cache buffers lru chain'
order by
   ws.ksllasnam,
   lw.ksllwlbl
;