Re: dba_extents vs dba_segments

From: Tim Gorman <tim_at_evdbt.com>
Date: Wed, 11 Mar 2009 09:55:09 -0600
Message-ID: <49B7DEDD.1070604_at_evdbt.com>

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_at_discover.com 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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

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

Received on Wed Mar 11 2009 - 10:55:09 CDT