Re: extents

David Yeung <dyeung_at_ust.hk> wrote:
>When I create a tablespace in Oracle, I need to specify
>the min/max/initial/ extents. Is there any document to
>describe the relationship between the tablespace size
>and the these extent values?
>
>Thanks
>
>david
>

For version 7 and 8 the Concepts manual has a good discussion of the use of these parameters. There is no direct relation between the size of the tablespace (number and size of files assigned to tablespace) and the setting of these parameters at the object or tablespace level. The proper values for these 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.

• Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice. --

  ---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jul 31 2000 - 00:00:00 CDT