Imagine that you are receiving an alert for Tablespace PSAPSR3 usage being at 99%. What are you going to do? Definitely you have to act quickly, so extension of this tablespace is needed.

You can use the following steps to do it, which describes the method via BRTools, on an UNIX machine:

1. First of all check the available free space in the sapdata filesystems:

df -m | grep sapdata

2. If you don't have enough space, you have to extend those FS's (more info how to do it ----> here)

3. If you have enough space then you have to switch to oraSID user and run brtools tool:

root>su - oraSID

oraSID>brtools

4. Press "2" ---> Equivalent for "Space management" operations:

5. Press "1" ---> "Extend tablespace"

6. Press "3" ---> "Tablespace name (tablespace)"

7. Type "PSAPSR3" and hit Enter

8. Press "c" ---> "Continue"

9. Press "c" again ---> "Continue"

10. Now BRTools will detect automatically the last datafile created, respectively in which sapdata filesystem was created, and will automatically fill the necessary fields for tablespace extension. You have to modify the option "3" ---> "New file to be added (file)" , only if you want the new datafile to be created in a different filesystem.

11. Press "c" to continue and wait for the extension to be performed.

In case you want the newly created datafile to have a specific size, then in step 10 you have to use also the option "5" ---> "Size of the new file in MB (size)" . Examples of values that should be entered here are:

32000 = 32GB

4000 = 4GB

10000 = 10GB