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

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 […]