News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script – Latch Contention (top 5 latches)

  • 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;
 

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *