O'Reilly logo

Expert Oracle RAC Performance Diagnostics and Tuning by Murali Vallath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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         ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required