Reduce the duration of ACT_TRANS for SUM

[benoit-schmid]

Hello,

The ACT_TRANS phase of the SUM has taken more than 5 hours

on a brend new host.

The machine was not overloaded as far as memory, cpu and io are concerned.

% grep 19.04.2013 log/SAPAAAA731.EH6

1 ED0305 Date, time...............: "19.04.2013", "07:26:30"

1 ED0305 Date, time...............: "19.04.2013", "12:57:31"

Is there any tuning or parallelization that can be configured to reduce this time?

Thanks in advance for your answers.

[Former Member · Accepted solution]

Hi,

Can you please check is all the oracle parameters are set correctly

For Oracle 11g, please check note: 1431798 - Oracle 11.2.0: Database Parameter Settings.

You can run the script attached to SAP note 1171650 to check which is the parameters to set in your system.

Rgds,

Sachin

[benoit-schmid · Accepted solution]

Hello,

Oracle Parameter check are ok with the script from the Note.

_use_zero_copy_io=false si not set.

What is the default value, if not set?

Regards,

[former_member188883 · Accepted solution]

Hi Benoit,

_use_zero_copy_io = true is the default setting.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi,

Set the Oracle initialization parameter _use_zero_copy_io=false

which disables the enhanced communication protocol for SecureFile LOB columns and restart the database instance.

For further details please refer SAP Note 1635605.

Rgds,

Sachin

[benoit-schmid · Accepted solution]

Hello,

When all parameters are set correctly, is there a parallelization that can be configured to reduce this time?

Thanks in advance for your answer

[former_member189797 · Accepted solution]

Hello Benoit,

There is no parallelism in the activation. Objects are dependent on each other so first dependency has to take care them only the object can be activated.

Regards,

Gaurav

[v_veeramalla]

Please refer to the note

1616401-Understanding parallelism during the Upgrades, EhPs and Support Packages implementations

[former_member188883]

Hi Benoit,

Can you please goto the t-code ST04OLD - > Detail analysis Menu - > Oracle Session

and check if there are many inactive sessions running. If it is the case, please refer the workaround

specified in the note

1635605 - CLIENT HANGS ON INSERT INTO TABLE WITH SECUREFILE LOB

Set the Oracle initialization parameter

_use_zero_copy_io=false

which disables the enhanced communication protocol for SecureFile LOB columns and restart the database instance.

After that please repeat the phase to continue with the upgrade.

Hope this helps.

Regards,

Deepak Kori

[former_member189797]

Hello Mr. Schmid,

ACT_TRANS : Activates ABAP Dictionary customer objects  (Similar to ACT_UPG phase).

If you check note:

1161052 - Add. Info: SAPehpi/SUM for Systems on Oracle

under section:

Necessary Preparations for the Enhancement Package Installation

Before starting the enhancement package installation please perform the

following steps. Failure to perform these steps may result in problems /

performance issues during the enhancement package installation.

4.  Apply all Oracle 10.2 interim patches mentioned in SAP Note 1137346

5.  Ensure that the database parameters are setup as described in SAP

    Note 830576

6.  Ensure that all database statistics are up to date by executing the

    following commands:

................

You can run the script attached to SAP note 1171650 to check which

is the parameters to set in your system.

If DB param is not correctly optimized, we cannot rule out the

cause of the long running phase eg: ACT_TRANS is

caused by the DB.

As you can see from the above note, ensuring the database parameters

are correctly set is the pre-requisite steps to avoid performance

issue during EHP installation.

I hereby also attach other relevant notes for your reference:

558197  - Upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2,

983548  - Long runtimes during SAP Upgrade using Oracle 10

This also apply for Oracle 11g, as not having the correct Oracle

Parameter Settings may result in longer runtime.

Some points to help analyze performance issue during this phase:

1. - Make sure the upgrade directory is local and not an NFS, to avoid

    network traffic.

2. -Check the job 'RDDMASGL' in shadow instance and see if there is

    any error. Monitor the EHP installation path DIR_PUT/tmp

    if the SAPA* log file is growing and increasing in file size?

    In the shadow instance, activities can be monitored from SM50.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

I am facing issue in Execution phase in ACT_TRANS . Where it is "activate abap dictionary customer objects" and the job is RDDMASGL for mass activation. This job is running from long and finally cancelled. I have restarted the phase again but still the issue is same. Please assist me what can be done to complete this phase completely.

Thanks,

Neel