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

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