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

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?