Re: Oracle 10g = bloatware?

From: onedbguru <onedbguru_at_yahoo.com>
Date: Wed, 11 Apr 2012 18:39:47 -0700 (PDT)
Message-ID: <9804014.307.1334194787778.JavaMail.geo-discussion-forums_at_vbiz13>

On Wednesday, April 11, 2012 5:41:46 PM UTC-4, ddf wrote:
> 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

OR, they have have had a LOT of inserts/deletes over time and never did a shrink space to clean it up (assuming ASSM). Received on Wed Apr 11 2012 - 20:39:47 CDT