Skip to Content

Primary checks on performance issues during upgrades using Oracle Databases

A lot of factors can affect the performance of an upgrade, like the table contents, DB size, tp and R3trans versions and so on.

The first check is to make sure that the latest versions of tp and R3trans are in use.

There are some phases like PARCONV_UPG, XPRAS_UPG and SHADOW_IMPORT that are phases of high database usage.

These phases perform different actions on the DB so it is important to rule out slow DB accesses to the DB initially.

On the other side, the reason could also be that many very big tables were handled, and therefore the tunning should be more focused on the applications analysis, archiving and other DB-realted tasks.

Make sure to check the following SAP notes, which deal with Oracle peformance:

   Regarding SAP software performance, these are the notes that can be checked in order to pinpoint and solve most of such issues:

Some other points to consider related to upgrade peformance issues:

  1. If the location of the datafiles (upgrade directory) is a local directory or a mounted remote directory. For a remote directory the connection speed to it is important;
  2. Even if the upgrade directory is local, network layer is used and thus network configuration is important. A typical difference between production and test systems can be that production is often high availability and thus can use e.g. virtual hostnames or other methods. Maybe the network setup is then different to non-production systems;
  3. Also hardware issues, e.g. if the database or the upgrade directory are on fast disks and if caches are used are important;
  4. If the database is on the host where SAPup and R3trans run or on a different host might influence the speed but even a local database access uses network layer and thus network configuration for the database host is also an issue.

If you have any other doubt make sure to check the SCN community of Software Logistics (

You must be Logged on to comment or reply to a post.
  • it would be nice if you could expand it in more details, that is, how to apply each note for particular phases, for example. i think also that there are differences in oracle 9, 10 and 11 versions, could please elaborate a little more on this, particularly on version 11*?

    thank you! bookmarked and liked!


    • Hi Julius,

      thanks for your inputs.

      Get in more detail it would about Oracle versions and so on would fall out the scope of the article, as these are only primary checks.

      I'm no Oracle expert, but AFAIK there's no difference among the versions. Maybe an Oracle expert could step in here.

    • Thanks Thiago, I will update the info.

      Also, do you have any remarks or tips regarding Julius' comments?

      " i think also that there are differences in oracle 9, 10 and 11 versions, could please elaborate a little more on this, particularly on version 11*?"

      • There are differences really, but as this is for preliminary checks I don't see much reason to get into detail. The parameter check from 1171650 will work on all versions for instance and patching the database is also recommended for all versions.

        Furthermore, 9i is already out of support and as for 10g only is still under extended support. You could have easily focused on 11g and that would be fine as well. 🙂