Skip to content
July 11, 2014 / doganay

IDENTIFYING HOT BLOCKS

with sq as (select object_name, data_object_id from dba_objects)
select hladdr cbc_latch_addr
,sum(tch) tch_sum
,listagg(tch || '-' || obj || '(' || object_name || ')/' || file# || '/' ||dbablk, ';')
within group (order by tch desc) "tch-obj(name)/file/blk_list"
,count(*) protected_db_blocks_cnt
from x$bh b, sq
where b.obj = sq.data_object_id
and tch > 0
group by hladdr
order by tch_sum desc;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: