SELECT 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 eWHERE  x.hladdr = '0000001123570C50'       AND e.file_id = x.file#       AND x.hladdr = l.addr       AND x.dbablk BETWEEN e.block_id AND e.block_id + e.blocks - 1ORDER  BY x.tch DESC;SEGMENT_NAME                     EXTENT#    BLOCK#       TCH    CHILD#------------------------------  --------  --------  --------  --------DWH.W_ORG_D                           70        44       260    251077DWH.W_GL_BALANCE_F                    48         ...

Get Expert Oracle RAC Performance Diagnostics and Tuning now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.