Latch Contention (top 5 latches)

This script will display the top 5 latches with the most sleeps.
Script can be changed to even sort the display on misses instead.

set linesize 120

col name format a30

select * from 

 (select name, gets,misses,  sleeps

 from   v$latch

 order by sleeps desc)

 where rownum < 6;