Review Metalink notes:- 463101.1 "HOW TO DISCOVER AND FIX THE MISMATCH BETWEEN DBA_SEGMENTS AND DBA_EXTENTS" - 271030.1 "Difference between BYTES in DBA_SEGMENTS and SUM(BYTES) in DBA_EXTENTS"
There might be more or newer notes as well... lots of forum threads too... genegurevich@xxxxxxxxxxxx wrote:
Hi everybody: I am running oracle 10.2.0.3 and it looks like the data in dba_extents and dba_segmetns views are not consistent. When I aggregate them on a owner level (select owner, sum(bytes/1024)/1024 from dba_???) the results from dba_extents seem to be different from dba_segments. I have opened an SR with Oracle a week ago and so far got nothing. I'm sure I am not the first to hit this issue - does anyone have a fix for that? thank you Gene Gurevich Please consider the environment before printing this email. -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l