Re: dba_extents vs dba_segments
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Mar 2009 23:41:52 +0800
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@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.
Gene Gurevich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
