Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: object # of extents
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...Received on Tue Jun 27 2006 - 14:32:16 CDT