Search notes:

Oracle: X$KSLLD

x$kslld stands for [K]ernel [S]ervice [L]ock [L]atch [D]escriptor.

Joining with x$ksmfsv

x$kslld can be joined x$ksmfsv to obtain a list of fixed SGA variables for latches:

select
-- count(*) over (),
   var.ksmfsnam  var_name  ,
   var.ksmfstyp  typ       , -- always ksllt
   var.ksmfssiz  size_     , -- always 160
   ltc.kslldnam  latch_name,
   ltc.kslldlvl  latch_level
from
   x$ksmfsv var                                join
   x$kslld  ltc on var.ksmfsadr = ltc.kslldadr
--where
-- var.ksmfssiz != 160
-- var.ksmfstyp <> 'ksllt'
order by
   var.ksmfsnam;

See also

Variable names in x$ksmfsv for latches