sapdba -next <tablespace(s)> (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

sapdba -next <tablespace(s)>
Use

You can use this SAPDBA command to adjust the value of the next extent allocated to growing tables in the Oracle database.

Recommendation

We strongly recommend you to use the BRCONNECT equivalent function -f next instead of this SAPDBA command. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

If you are reorganizing a tablespace that grows quickly (for example, a tablespace with transaction data), we recommend using this command frequently. SAPDBA adjusts the value of NEXT according to the rapid growth of the tablespace. Adjusting NEXT prevents the tablespace from reaching the MAXEXTENTS limit too quickly.

SAPDBA chooses the new value for NEXT as the maximum of the following two values:

An SAP object is assigned a size category from table DD09L . The NEXT value is determined from table TGORA / IGORA based on the category. If the table has no category assigned in DD09L , this value is not generated.

SAPDBA chooses the maximum of the following values:

The current NEXT value

10% of the total allocated space

SAPDBA compares the new chosen value for NEXT with the values for the extent size in TGORA / IGORA . SAPDBA chooses the next smaller value found in TGORA / IGORA as the new NEXT value. If there are no entries for the table in TGORA / IGORA , SAPDBA uses an internal default value. See also Default Value for NEXT.

This procedure prevents the number of extents from growing too quickly and – with repeated use – simulates an asynchronous, linear PCTINCREASE response. The changed tables are recorded along with their old and new values in the log <timestamp>.nxt . For more information on the log, see SAPDBA Log Files and Their Contents.

Syntax

The following are examples of the syntax for this command:

Example

For all SAP tablespaces:

sapdba -next PSAP%

For all SAP index tablespaces:

sapdba -next PSAP%I

For the tablespaces PSAPBTABD and PSAPBTABI :

sapdba -next PSAPBTAB%

For single tablespaces that grow quickly, for example PSAPBTABD (run this command for these tablespaces more often):

sapdba -next <tablespace_name>

For a list of tablespaces (note that there is no space between the tablespace names):

sapdba -next <TSP_name1>,<TSP_name2>,...

Caution

You cannot change the NEXT parameter for the SYSTEM tablespace.