Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Upgrade 4.6C to ECC 6.0 5 Tb Oracle 10g database takes too long


We´ve just run an upgrade test with a 5Tb database and takes too long so our downtime will be more than 3 days, is there any documents that can lead us to get a better downtime some way

Any help will be appreciated.


4.6C (4.6D ext kernel)

Oracle 10g with 5Tb of data


Former Member replied

I think I may be qualified to answer your questions.

our database is 2TB and the technical down time is only 6 hours. Hopefully this benchmark can make your feel comfortable.

If you read some SAP presentation, the downtime is not related with the database size. so even your database is double our size, the downtime may not be doubled.

The tricks for reducing the downtime is simple. You need to have a good Basis/DBA. The first time should be painful but you need to find all the way to speed it up. Here are some common ones.

1. Search for SAP notes to see which processes could be run in parallel.

2. Watch the database to identified slow SQLs. You can add indexes to speed it up.

3. Check the stats for new tables during the upgrade. The new tables could cause some execution plan problems.

4. It is hard to say you need to archive some tables or not. As SAP says it depends. It will be difficult running archiving project with upgrade project.

The bottom line is a good Basis. Every software is peopleware.

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question