- Posted by Gavin Soorma
- On July 6, 2009
- 0 Comments
- latch, misses, sleeps, v$latch
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;