Re: object # of extents

Mark D Powell wrote:
> Frank van Bortel wrote:
> > Ben schreef:
> > > Running Oracle 9.2.0.5 Ent Ed, DMTs, UNIX AIX5L, compatible parameter =
> > > 8.1.0
> > >
> > > That should raise some concerns of it's own, but on to the question.
> > >
> > > Is there a certain number of extents for objects that one should start
> > > to become worried or concerned? If a table reaches say 1500 extents
> > > should I start to think about reorganizing the table? What would be the
> > > best method to reorg, exp/imp, alter table move? Can someone point me
> > > in the direction of a good guideline on when this should become a
> > > concern?
> > >
> > > Thanks,
> > > BA
> > >
> > On 9i, release 2, you should really get used to locally managed
> > tablespaces with auto segment space management.
> > In that case, you will probably never even *have* 1500 extents!
> >
> > And I start worrying at about 4000 (four thousand) extents. And
> > even then, I doubt it would be "a concern".
> >
> > --
> > Regards,
> > Frank van Bortel
> >
> > Top-posting is one way to shut me up...
>
> I will disagree on the use of ASSM. Way too many bugs in this feature
> still on 9.2 plus the feature has fairly high space overhead on small
> objects in multiple extents. But locally managed tablespaces are the
> way to go. I prefer uniform extents.
>
> HTH -- Mark D Powell --

well, how about 8000 then? Received on Wed Jun 28 2006 - 10:33:48 CDT