These tools are provided by SAP for Oracle Database.
- Login as SIDADM on windows or ORASID on UNIX
- command BRTOOLS
Type option 2 for Space management.
Option 7 for additional space function.
Option 1 show tablespaces
Continue 3 times to display the list of table spaces and their growth.
DB13 - Tablespace Particular (DBA Planning Calendar)
DB12 - Overview for a Database
Identify the tablespaces which are grown more than 90% and add datafiles.
Enter choice - 1 (For which tablespace we need to increase the size of datafile)
PSAPSR3700 - Press Enter
In this path 16 datafiles are there if we increase the tablespace size one more data file is created called sr3700_17
SQL> select tablespace_name, blocksize from dba_tablespaces;
- Add the datafile or resize datafile before its gets an error message "Tablespace overflow"
See more about SAP BASIS