Re: dba_extents vs dba_segments

From: ajay c <ajaycajay_at_gmail.com>
Date: Wed, 11 Mar 2009 12:23:05 -0400
Message-ID: <9b08a9b40903110923h1ecfc1f0q1643b371b9f55ee7_at_mail.gmail.com>

How much is the difference?
Is this a uniform extent locally managed tablespace with big uniform extent and having big objects having more than 1 million extents? If so then there is a bug for that.

On 3/11/09, genegurevich_at_discover.com <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 - 11:23:05 CDT