Re: extents

On Mon, 31 Jul 2000 06:57:02 -0700, Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid> wrote:

>depend mostly on your tablespace space management policies. I
>believe that Oracle currently recommends to assign the same
>extent size to all objects in the tablespace, initial=next and
>pctincrease=0. This makes every free extent available for use
>by any object that needs to extend. I think it is more
>important to organize large objects this way than it is for
>small objects.

Hehehe! They _finally_ recomending that? Been using it since V6, 12 yaears ago...

On another note: going this way, it's handy to separate your database into volatile tables and static tables. Then for each group, there should be a "small" tablespace, a "middle" tablespace and a "large" tablespace. Not necessarily in overall size but more to do with the default storage parameters of the each tablespace. And of course, try to have all extents within the same tablespace the same size. That makes free space and used space management and defragmenting easy as pie.

This is a minimum. Of course, there are more refinements to make, but that's highly case-by-case.

HTH Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Tue Aug 01 2000 - 00:00:00 CDT