Oracle Tablespaces are full

[Former Member]

Hello!

I have detected through monitoring in Solution Manager that I have a Tablespaces bottleneck in one of the satellite systems.

The tablespace PSA<SID> as well as SYSTEM are almost 100% full.

How can I resolve this problem

a) with SAP resources

b) on the OS layer with sqlplus "/ as sysdba" ...

Thank you very much!

regards

Thom

[Former Member]

Hi,

You can use either of the methods, but SAP Recommends to use BRTools.

So, you can extend the file or add new datafile to the tablespace.

Regards,

Santosh

[Former Member]

i use sqlplus it's easy for me.

sap recommend brtools but this one use the some request "add datafile ...."

so we can use sqlplus

brtools it's not easy

bye

[fidel_vales]

Hi,

I do not think BRTOOLS is difficult.

it is menu driven, and quite easy.

If a datafile is added, it will follow SAP standards, it automatically creates the needed directories, you only have to fill the required data ( size of the datafile, location, if you want it autoextend ... )

If you add a datafile manually, it will not follow SAP standards and then, you can have errors using BRTOOLS later on.

Another problem I found is people that tries to use BRTOOLS without

- having a DB knowledge

- having a clue what they want to do

- having read the documentation ( available in the internet at http://help.sap.com or )

[Former Member]

Hi,

you can use brtools for that.If the data file size is >= 2GB then you have to add new file or else you just increase the current file size .To know the current data fil name and size run transaction code DB13 and select current size and select the tablespace name and click on "data fil/size" in the menu.

You can do at sql level also ,but its not preffered.

Regards,

Ramarao.A

[former_member204746]

to extend/resize an existing datafile:

brspace -c -u / -f dfalter

to add a datafile:

brspace -c -u / -f tsextend

do not use sqlplus, you might create datafiles that does not use SAP's naming convention. and you cannot manage tablespaces/datafiles through SAPGUI.

[Former Member]

Using brtools 9 brtools --> space management ) extend the table spaceor add new datafile. You can also resize the datafile and extend the tablespace

Thanks

Prince Jose