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;

Posted by Gavin Soorma
On June 29, 2009
0 Comments

select count(*) child_count, sum(gets) sum_gets, sum(misses) sum_misses, sum(sleeps) sum_sleeps from v$latch_children where name = 'cache buffers chains'; select p1 "File #". p2 "Block #" from v$session_wait where event ='cache buffer chains'; select owner, segment_name, segment_type from dba_extents where file_id = &P1 and &P2 between block_id and block_id + blocks -1; col object_name format a20 col […]

News

Script – Latch Contention (top 5 latches)

Identify 'hot' objects when faced with 'Cache Buffers Chains Latch' wait event