select CHILD# "cCHILD" , ADDR "sADDR" , GETS "sGETS" , MISSES "sMISSES" , SLEEPS "sSLEEPS" from v$latch_children where name = 'cache buffers chains' order by 5, 1, 2, 3; prompt This [sleep count] value (obtained from the sSLEEPS column of the query output) is used as the lower prompt bound for the search for relevant block accesses. Any value of the sSLEEPS column can be used to run prompt the second query. However, you should choose a relevant value from the top "n" resulted values. column segment_name format a35 select /*+ RULE */ e.owner ||'.'|| e.segment_name segment_name, e.extent_id extent#, x.dbablk - e.block_id + 1 block#, x.tch, l.child# from sys.v$latch_children l, sys.x$bh x, sys.dba_extents e where x.hladdr = '&ADDR' and e.file_id = x.file# and x.hladdr = l.addr and x.dbablk between e.block_id and e.block_id + e.blocks -1 order by x.tch desc ; prompt Depending on the TCH column (The number of times the block is hit by a SQL statement), you can identify prompt a hotblock. The higher the value of the TCH column, the more frequent the block is accessed by SQL statements. prompt refer to Note 163424.1