Loop gets struck after Oracle and Kernal upgrade

[Former Member]

Hi,

We have migrated to oracle 11.2.0.4 and Kernal 720_EXT_REL. There seems to be few select statements which are getting struck after the upgrade and which used to work fine befor the upgrade.

Has any one faced this kind of issues before? If yes, was there any note implemented for the same?

Regards,

Anand.

[sunny_pahuja2 · Accepted solution]

Hello,

Have you implemented Oracle parameter recommendations as per SAP note 1431798?

Thanks,

Sunny

[Former Member · Accepted solution]

It Worked...Thanks for the help.

[ACE-SAP]

Hi

What was the source version, what is you operating system, how do you upgrade / migrate ?

Did you apply latest Bundle patch ?

=> By the way version 11.2.0.4 is not validated by SAP yet (should be there in Q1/2014 but not yet available).

More information is needed to be able to help you.

Did you check perf reports available in DB02, what did you notice there ?

11g can bring some drawbacks for sub optimal SQL queries...

Job slower after upgrade from Oracle 11.2.0.2 to 11.2.0.3

Check that post that introduce on bad point that can lead to performance problems when migrating to 11.x version.

Did you schedule statistics update (system stat, ddic stac & data stat ?)

838725 - Oracle 10.2: Dictionary and system statistics

Did you update SAP specific table stat scripts ?

1020260 - Delivery of Oracle statistics

Did you suspend Oracle internal jobs ?

974781 - Oracle Internal database maintenance jobs

1579946 - Oracle 11g: Resource Manager with 11.2

Regards