Search notes:

v$latch

Oracle collects (aggregated) statistics for the activity of all latches and stores these in v$latch.
gets is the number of successful willing to wait requests for a latch.
Similarly, misses is how many times a process didn't successfully request a latch.
spin_gets: number of times a latch is obtained after spinning at least once. Sleeps indicates how many times a willing to wait process slept.
waiters_woken tells how often a sleeping process was »disturbed«.
select
--lnm.name,
  lat.name,
  lat.addr,
  lat.gets,
  lat.misses,
  lat.sleeps,
  lat.immediate_gets,
  lat.immediate_misses,
  lah.pid                   latch_holder_pid
from
  v$latch       lat                              left join
  v$latchholder lah on lat.addr    = lah.laddr /*left join
  v$latchname   lnm on lat.latch#  = lnm.latch# */
order by
   lat.gets desc;
Github repository oracle-patterns, path: /Installed/dynamic-performance-views/latch/show-statistics.sql

See also

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

Index