difference in space_allocated_total in dba_hist_seg_stat and dba_segments

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Tue, 6 Apr 2010 10:54:09 +0000 (GMT)
Message-ID: <930324.2397.qm_at_web29018.mail.ird.yahoo.com>

Hi
I am using the below query to identify segments with high growth rate select
ds.segment_name "Object Name",
round(sum(space_allocated_total) / 1024 / 1024) "Growth (MB)" , round(sum(space_used_delta)/1024/1204)
from

dba_hist_snapshot dhs,
dba_hist_seg_stat dhss,
dba_objects db,
dba_segments ds

where begin_interval_time > trunc(sysdate) - &days_back and dhs.snap_id = dhss.snap_id

and db.object_id = dhss.obj#
and db.owner = ds.owner
and db.object_name = ds.segment_name

group by ds.segment_name
having sum(space_allocated_delta) / 1024 / 1024 >5000 order by 3 desc
output is something like this
Object Name      space_allocated_total space_used_delta

---------------- ----------------      ----------------
SYS_LOB$$        77563706              351032732

CHILDREN         121527819             369147 REF_T            93489919              148680 select segment_name,round(sum(bytes)/1024/1024) from dba_segments
where segment_name in ('SYS_LOB$$',
'CHILDREN',
'REF_T'

)
group by segment_name
SEGMENT_NAME     ROUND(SUM(BYTES)/1024/1024)

---------------- ---------------------------
CHILDREN         199436

REF_T            359347
SYS_LOB$$        514696
why is the difference in space_allocated_total in dba_hist_seg_stat and dba_segments  

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 06 2010 - 05:54:09 CDT