Re: Oracle 10g = bloatware?
From: ddf <oratune_at_msn.com>
Date: Wed, 11 Apr 2012 14:41:46 -0700 (PDT)
Message-ID: <c28bd427-47ce-4761-8cbc-9fbdc32bfbc1_at_2g2000yqp.googlegroups.com>
On Apr 11, 9:42 am, Kay Kanekowski <kay.kanekow..._at_web.de> wrote:
> 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
Date: Wed, 11 Apr 2012 14:41:46 -0700 (PDT)
Message-ID: <c28bd427-47ce-4761-8cbc-9fbdc32bfbc1_at_2g2000yqp.googlegroups.com>
On Apr 11, 9:42 am, Kay Kanekowski <kay.kanekow..._at_web.de> wrote:
> 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
You have that backwards:
10g == 945 MB
11g == 211 MB
But I, too, am wondering why there is so much apparent free space in the 10g copy of the table. Possibly someone did this in 10g:
alter table flow_files minimize records_per_block;
or maybe manual segment space management is in use in the 10g database and the pctfree is set to a high value.
David Fitzjarrell Received on Wed Apr 11 2012 - 16:41:46 CDT