Re: Attentions DBAs - Does this make sense

I am planning to keep the size of
NEXT EXTENT 1M for all tables since this will aid the reusage of them when

they are free. This might be an overkill for small tables, but it maintains consistency. <<

Yes, it makes some since, but depending on how many tables you have, how fast they grow, how predictable the growth rate is, and how different there are in size you could be wasting a lot of space. Still disk is pretty cheap.

But if you have, let us say, one table whose total space requirements exceed your initial extent and over a couple of months triples in size you may find that the table or index is in a lot of extents. This may or may not be a problem depending on your version of Oracle, database block size, and multi-block read count.

You may find that separating the large objects to their own tablespaces worth while. You are in the best position to judge.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Mon Jun 23 1997 - 00:00:00 CDT