Specify a large value for the INITIAL extent of tables or indexes that grow quickly, allowing for future growth. This means that the database does not have to immediately assign a new extent.

Specify a smaller value for the INITIAL extent when you know that a table or index is unlikely to grow significantly.

This is the size of the second and all other extents assigned to a table or an index. This value is usually calculated using tables DD09L and TGORA / IGORA . See Default Value for NEXT.

You can generally leave the NEXT value set to the SAPDBA default value. However, if you have made large changes to the INITIAL value, increase or decrease the value of NEXT accordingly.

This is the initial number of extents when the table is created. It is normally set to 1. The exception is when the INITIAL extent must be split because of the free space available or the data file size. In this case, SAPDBA changes the value for MINEXTENTS independently.

This is the maximum number of extents allowed for the table. For more information, see Limitations of the Oracle Database System.

This refers to the percentage increase in the NEXT extent size. It is always set to zero by SAPDBA and cannot be changed manually with SAPDBA. This prevents exponential growth of extent sizes in all SAP tables. As a result, NEXT is the size for all new extents assigned after the first one.

However, you can simulate an asynchronous, linear PCTINCREASE response by using the command option sapdba -next . Refer to sapdba -next <tablespace(s)>.

When a data block is full (except for the space for PCTFREE ), no new rows are added to that block. No more rows can be added to that block until the percentage of used storage falls below the value of PCTUSED . The default value is 40%.

PCTFREE and PCTUSED are used to optimize use of the storage space in the extent data blocks. Both parameters can be specified for tables. For indexes only PCTFREE can be specified.