Reduce Disk Space on SAP ERP System with Oracle DB

[former_member598106]

Hello Everyone;

My question is a general one but I need to ask it so I can know where to start my investigation:

I need to reduce the size of the disk space of our SAP systems as it is expanding with time, and to reduce the cost of the space the management asked how we can reduce any unneeded space on SAP systems.

Do you have any suggestion where to start so we can have only the required space without having any unneeded space or data on the system.

We are willing to remove unneeded data like the historical records.

Best Regards

Amal Aloun

[hariom_garg · Accepted solution]

Hi Amal,

Yes, you can reduce the database size by following below points:-

1. extract the list of large table from db02 which are having size more then 5 GB and then perform online table reorg on those tables.

2. you can delete old logs from tables like Baldat etc.follow below SAP note to delete logs of tables

https://launchpad.support.sap.com/#/notes/2388483

3. you can perform offline reorg of SAPDATA1 this can also release space at DB level as well in file system as well using advance oracle compression

Regards

Hariom

[dasistdochscheisse]

Afrter a while the file systems for //usr/sap/<SID> and /sapmnt should be in a state in which they re not growing so much more if the housekeeping is done properly.

Do you use Compression of tablespaces? That can really save disk space. Reorg of big tables and/or tablespaces could save disk space if you do it regularly, otherwise it is just usefull for a couple of weeks/months. PSAPTEMP und PSAPUNDO could be too big, check on the usage of them.

[janos_mucsi-besze]

I recommend to use Oracle Advanced compression, as it constantly (kind of) compresses data.

From our perspective, this is the best possible way to spare disk space.

[Sriram2009]

Hi Amla.

1. Are you having an retention policys of logs defined in your ERP system?

2. Either every day or weekly once are you running SAP standard background jobs? refer the SAP note 16083.

3. Find the top 20 tables from the DB02. take necessery action with help of Business & Functional support team.

4. what is you DB size? every day are you clearing the transaction log after taken the backup?

Regards

SS