sap system slow after upgrade

[Former Member]

Hi All,

recently we have done oracle upgrade from 9.2.0.8 to 10.2.0.4.i have done the postupgrade scripts and application was fine.But,few days back, the table ARFCRSTATE is occupying more dialog work process and users are facing slowness in the SAP application.I have ran the updates stats daily and still am facing this issue.Can anyone provide me a help on this

i have checked st02,st04 and hardware related and i am not having any problem related to above these.Kindly provide me your valuable solutions

Sunos5.9/oracle10.2.0.4/ecc5

Regards

Ram

[Former Member · Accepted solution]

Hi,

we had similar problems, please check following notes and create 'special' statistics:

Note 932975 - Oracle statistics for RFC tables

Note 1020260 - Delivery of Oracle statistics (Oracle 10g, 11g)

BR,

Peter

[Former Member · Accepted solution]

Hi PETER,

can you guide in short what has to be done using the note 1020260.i am having brtools 7.0 version(patch 52).i have to download the script and what has to be done.......

i did not get it clearly from that note.Please help me ...

Regards

Ram

[Former Member · Accepted solution]

Hi Bharatram,

- firstly you will need to update your brtools to version at least 7.10, patch 25 (see SAP Note 12741).

- secondly we adjusted the script to create stats only for RFC tables (attached), then

     - rename attached RFC_STAT.txt to RFC_STAT.SQL

     - logon to OS as ora<sid>

     - run: sqlplus /nolog @RFC_STAT.SQL <SCHEMA_OWNER>

     - check created file RFC_STAT.out

Use at your own risk.

BR,

Peter

RFC_STAT.txt.zip