Checks for Tablespace Extension and Creation (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Checks for Tablespace Extension and Creation

When you use SAPDBA for Oracle to extend an existing tablespace or create a new tablespace – both of which involve adding a data file – SAPDBA performs certain checks, which are described in this section.

Before an additional file is added, SAPDBA performs the following checks (if file systems are used):

The following block sizes ought to be identical:

Block size	Used in
Filesystem block size	File system
Filesystem fragment size	File system fragments
Oracle block size	Database system

SAPDBA verifies that the above values are identical. If not, it issues a warning message and suggests selecting a new file system. We recommend that you ignore the warning because previous problems have been solved in current operating systems.

Also note the following:

The Oracle database block size is always 8 KB in the SAP System.
SAPDBA does not perform the check under the AIX operating system, as the block sizes are always different:

Block size for	Block Size
Oracle	4 KB
Filesystem	8 KB

For OSF1, the value for "filesystem fragment size" is always 1 KB, and so SAPDBA does not check it.

SAPDBA checks that there is sufficient storage in the file system proposed for the new file. If not, SAPDBA does not add the file.

If these checks were successful, SAPDBA adds the data file to extend the tablespace or create a new tablespace.