Re: dba_extents vs dba_segments

We aren't sure WHAT is the discrepancy that you see -- whether it relates to specific types of segments or depends on extent sizes. See MetaLink Note#463101.1

Hemant K Chitale
http://hemantoracledba.blogspot.com

At 10:57 PM Wednesday, 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.
>
>Gene Gurevich

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