dba_extents vs dba_segments

  • From: <genegurevich@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 11 Mar 2009 09:57:18 -0500

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.


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


Other related posts: