Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 09 at 02:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14 at 11:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 16 at 02:35 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded