Re: dba_extents vs dba_segments

From: Jared Still <>
Date: Wed, 11 Mar 2009 08:44:25 -0700
Message-ID: <>

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

> I am running oracle 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: *

*... 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.


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

Original text of this message