Check Functions 

You can check whether (and which) tablespaces would overflow if an additional n extents were assigned.

Overflow check for all tablespaces. Displays a list of the tables for which assigning an additional n extents would cause the corresponding tablespace to overflow.

Overflow check for one tablespace. Select Enter tablespace name and enter the name of the tablespace. Displays a list of the tables for which assigning an additional n extents would cause the corresponding tablespace to overflow.

Which Table or Index Caused the Overflow?

Occurrences of the ORACLE error (tablespace overflow) are recorded in the R/3 System log (along with the table/index that was accessed).

You can then determine which tablespace the table/index belongs to - with SAPDBA, for example - using the function Check free space for objects in all tablespaces with test value 1.

Tablespace Overflow Threshold Values

Extend the tablespace as soon as possible. Exception: the tablespaces PSAPPROTD/I contain SAP logs (from background processes and spool requests). Delete old log files and requests instead of extending these tablespaces.

Monitor the tablespace.

The tablespace currently has sufficient free storage space. No intervention is necessary, provided the tablespace continues to be used normally. Important: if you change the storage parameters or perform operations in the R/3 System that will fill this tablespace more quickly, you should monitor it as well.

Database Monitor

The database performance monitor of the R/3 System also provides information on how urgent a tablespace extension is.

For more information, refer to the online help of the Computing Center Management System.