Re: determining extent sizes

I would suggest to see the growth pattern too, just to set up the pctfree and pctused parameters. Also, if the size of the table is given for over a period of time, I would create table with the initial size of first two years and see the growth and then decide the extent size later.

Vijay

Michael Abbey wrote:
>
> My feeling is to always allocate one extent large enough for the whole
> table.
>

> Michael
>
> chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>
> >I'm curious as to what other DBAs do when creating new tables. Is it
> >better to:
 

> >1) estimate actual table sizes and create the initial extent to be
> >that size,
 

> >or
 

> >2) make all extents the same size so it's easier for the RDBMS to
> >reuse free'd up extents?
 

> >--
> >Chuck Hamilton
> >chuckh_at_ix.netcom.com
 

> >Never share a foxhole with anyone braver than yourself!
Received on Thu Jan 18 1996 - 00:00:00 CET