Re: dba_extents and dba_segments

It's a bug, seen in 9.2.0.x (not sure exactly which point-version), I think I remember -- what version are you using (always useful to include in your original post)?
Scan MetaLink on keywords like "DBA_SEGMENTS DBA_EXTENTS BYTES". If I recall, it had something to do with having more than 100,000 segments or extents in a tablespace or datafile -- a very surprising and disturbing bug, but ultimately only of concern to monitoring tools. I believe that the SUM(BYTES) from DBA_EXTENTS was correct and that BYTES in DBA_SEGMENTS was incorrect. Classic "buried update" problem, perhaps? 



genegurevich@xxxxxxxxxxxxxxxxxxxxx wrote:

I don't think this is the case:

  1* select sum(bytes/1024)/1024 from dba_segments where segment_name like
'BIN%' and tablespace_name = 'CCS_X_017'
SQL> /

SUM(BYTES/1024)/1024
--------------------

There is no dropped objects in this tablespace.

thank you

Gene Gurevich
Oracle MySQL Operations - OMO
224-405-4079
"Allen, Brandon" <Brandon.Allen@On eNeck.com> To <genegurevich@xxxxxxxxxxxxxxxxxxxxx 05/09/2007 04:26 >, <oracle-l@xxxxxxxxxxxxx> PM cc Subject RE: dba_extents and dba_segments 


Just a guess - maybe the dba_segments view filters out dropped objects
(i.e. those in the recycle bin), while dba_extents does not?


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

Other related posts: