Re: dba_extents vs dba_segments

On Wed, Mar 11, 2009 at 7:57 AM, <genegurevich@xxxxxxxxxxxx> wrote:

>
> 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?
>
>
While I think I know what you are referring to, I am not sure.

Perhaps after reviewing this: *http://tinyurl.com/how-to-ask-questions

*... you would include a reproducible example and point out the
exact data that you believe is in error.

Version and platform information wouldn't hurt either.

Jared

Other related posts: