Re: Is there a performance limit of extents?

        I just read a report from Oracle consulting where the consultant advised reorganizing the database in order to bring all tables and indexes under 20 extents in order to improve performance. My personal preference is for no more than 10 extents per table or index and I am happier when I have less than four.

        Based on that I think your extent sizes are okay, by the way, I presume you are planning on one tablespace for each extent size with PCTINCREASE 0 in order to eliminate the need to ever coalesce or reorganize your database ;-) I do think that you should change the table size ranges for each extent so that you have no more than 10 extents per table.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/17/00, 1:43:07 PM, Gonzalo <gonzarg_at_my-deja.com> wrote regarding Is  

there a performance limit of extents?:

> Hi,
> I'm migrating to Oracle 8.0.5 - Solaris 2.7.
> I know exactly the size of my tables. The question is:
> Which is the better extent size? Is there a rule for this?
> I was told than in earlier version of Oracle, having more
> than 20 extents in a segments, is not recomended (performance
> decrease), is it true?
 

> The rule I'm using is the following:
> Table Size EXTENTS SIZE
> 0 a 5 MB 64kb
> 5Mb a 50 Mb 1Mb
> 50 Mb a 100Mb 10Mb
> > 100 Mb 50Mb
 

> but I m not sure it's rigth
 

> Any help will be apreciated,
 

> Thanks,
> Gonzalo.

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 18 2000 - 00:00:00 CDT