Skip to Content
0

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

Feb 04 at 06:59 AM

68

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

James Zhang
Feb 09 at 02:12 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Janos Mucsi-Besze
Feb 14 at 11:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Reagan Benjamin
Feb 16 at 02:35 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded