1. Home
  2. Knowledge Base
  3. Performance Tuning
  4. Script – Latch Contention (top 5 latches)
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Script – Latch Contention (top 5 latches)

Script – 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;
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Leave a Comment