Re: dba_extents vs dba_segments
- From: Tim Gorman <tim@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Wed, 11 Mar 2009 09:55:09 -0600
Review Metalink notes:
- 463101.1 "HOW TO DISCOVER AND FIX THE MISMATCH BETWEEN DBA_SEGMENTS
AND DBA_EXTENTS"
- 271030.1 "Difference between BYTES in DBA_SEGMENTS and SUM(BYTES) in
DBA_EXTENTS"
There might be more or newer notes as well... lots of forum threads too...
genegurevich@xxxxxxxxxxxx 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
