After DB Migration Oracle 10.2.0.5 to 11.2.0.3 performance issue

[former_member215961]

Hi experts,

Key users reported to me that after migrate Oracle 11g whole business processes are slower than the past sistem wirth 10g.

First we update oracle statistics as per note1020260 from all the 3 kinds of oracle statics to improve CBO procedure.

Later we wondered that without a complete ( E2E ) analisys it was imposible to solve those performace issues.

We open an OSS ticket and all recommendations were create index for SQL statements.

SAP RELEASE :4.7 set 2.00

Oracle 11.2.0.3 Opatch ( January 2013 )

Somebody were on similar situation ?

Cheers

[mario_bisonti2]

Hallo.

I have performance degratation upgrading from 11.2.0.2 to 11.2.0.3

Did you solve the issue?

Thanks

[former_member188883]

Hi Sargan,

Is the entire system is slow or only specific transactions are slow.

If specific transactions are slow please share relevant details.

Also have you included all the database specific parameters as specified in SAP note Note 1431798 - Oracle 11.2.0 Database Parameter Settings.

If not perform the changes and check the results.

Hope this helps.

Regards,

Deepak Kori

[former_member215961]

Hi,

Users report that billing proces is slow and transactions are the same...

Parameters has been checked.

Cheers