Re: Oracle 10g = bloatware?
From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Wed, 11 Apr 2012 17:42:58 +0200
Message-ID: <jm48q4$dcg$1_at_news.albasani.net>
Am 11.04.2012 16:37, schrieb Matthias Hoys:
> This is on 10g:
> select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES';
> MB
> 945.75
>
> This is on 11gR2, after export/import using Data Pump:
> select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES';
> MB
> 211.75
>
> ??? The number of rows are the same, tablespace properties too...
>
>
> Matthias Hoys
Date: Wed, 11 Apr 2012 17:42:58 +0200
Message-ID: <jm48q4$dcg$1_at_news.albasani.net>
Am 11.04.2012 16:37, schrieb Matthias Hoys:
> This is on 10g:
> select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES';
> MB
> 945.75
>
> This is on 11gR2, after export/import using Data Pump:
> select sum(bytes)/1024/1024 MB from dba_extents where owner = 'FLOWS_FILES';
> MB
> 211.75
>
> ??? The number of rows are the same, tablespace properties too...
>
>
> Matthias Hoys
Hi Matthias,
what is the right posting ? In your posting from 16:35 the 10g sum is
211 MB and 11g sum is 945 MB.
If the sums in this thread are real then i expect there will lot a of
free space in the dba_extents. And the export/import is the old
fashioned way to elimante this free space. Test it in the 10g database
with some 'alter table ... move' statement. The sum of bytes in
dba_extents will be smaller than now.
hth
Kay
Received on Wed Apr 11 2012 - 10:42:58 CDT