Proracle’s Weblog

April 24, 2008

Hot Block ??

Filed under: useful — proracle @ 1:22 pm
Tags:
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;
Advertisements
Next Page »

Create a free website or blog at WordPress.com.