Re: dba_extents vs dba_segments

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 11 Mar 2009 08:44:25 -0700
Message-ID: <bf46380903110844l3fe67fabhd8cfaf8093f590f3_at_mail.gmail.com>

On Wed, Mar 11, 2009 at 7:57 AM, <genegurevich_at_discover.com> 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

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

Received on Wed Mar 11 2009 - 10:44:25 CDT