Re: dba_extents vs dba_segments

From: Hemant K Chitale <>
Date: Wed, 11 Mar 2009 23:41:52 +0800
Message-Id: <>

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

At 10:57 PM Wednesday, wrote:

>Hi everybody:
>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.
>Gene Gurevich

Received on Wed Mar 11 2009 - 10:41:52 CDT

Original text of this message