Hi all,

I was wondering...
I have to set up a new database. I know my row sizes and approximate number of records. Depending on the growth rate of my tables, is it better to have less extents (but bigger), or more extents (but smaller).

My personal idea (could be wrong) is :

For tables that will not grow much, a bigger extent
For tables that will grow often, more smaller extents.

Is this O.K. ??
Any better suggestions??

BTW....It is under Oracle 8.1.7

Thanks