October 2014
Intermediate to advanced
712 pages
21h 28m
English
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 ...
Read now
Unlock full access