Script – Latch Contention (top 5 latches)
- Posted by Gavin Soorma
- On July 6, 2009
- 0 Comments
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;
Read More