Tables consumed more space after migrated to SAP 740 ehp8 and database is oracle12c?

[Former Member]

Hello Experts.

I'm new to the SAP BASIS.

We have migrated our SAP Environment to SAP 740 EHP8 and database to Oracle12c on last year October-16. But PSAPPRD table consumed approximately 15GB on every month after migration. But before the migration it was consumed 8.5GB only on each month.

please help me to analyse the issue.

Siva.

[Reagan]

Your question is not clear. When you say "migration" does that mean the system was migrated from another OS/DB to Oracle database? Or are you saying that the SAP system was upgraded from an older release to EHP8. EHP8 is based on NW 7.50 and not 740 like you said. PSAPPRD is a tablespace and not a table. You need to find out the objects in the PSAPPRD tablespace responsible for the tablespace space consumption.

[janos_mucsi-besze]

Hi Siva,

I guess you are talking about tablespace PSAPPRD and not about a table as the name looks like to be a tablespace name.

Here we have to check if you used the latest available SWPM for the migration.

Besides this, the tablespace may have been compressed on Oracle level before the migration, whereas the compression might not be selected for the sam tablspace during the migration project within SWPM. So at the end you may ended up in an uncompressed tablespace. This would explain the difference.

Regards,

János

[JamesZ]

Hi Siva,

Normally this is "application" demands, so did you check which table or index increased more heavily?

So far in 12c, oracle only has one bug reported for such issue, for the details, please refer to SAP note ##2538588.

Best regards,
James