Error with action u201CSequential Readu201D with Tableu201D USER_ADDR

[Former Member]

Hi,

I get a problem when I call Tcode u201C SU01u201D and chose u201CF4u201D and search by user by address data, the system is get hanging in action u201CSequential Readu201D with Tableu201D USER_ADDRu201D, and get result after 5 minutes,

This case with SAP ECC 6 windows 2003 Oracle 10 G with:

u2022 Latest Software components u201C16u201D for u201CSAP_ABA & SAP_BASISu201D

u2022 All Enhancements Package already installed

u2022 Kernel 159

When I check from OS level I can see Windows Task Manager with Performance tape page itu2019s reached to 100% while I run the transaction,

Hint:

u2022 Total users available is 119

u2022 CUA already implemented in SAP Solution Manager

Please advice.

Regards,

Ahmed Saber

[Former Member]

Hi Satyabrat Mohanty,

Thanks for reply,

This scenario on SAP ECC 6 QAS system with:

u2022 5.75 GB of RAM

u2022 Paging 20000 MB

Regards,

Ahmed

[Former Member]

Hi,

As you are on Oracle 10g, please make sure you have performed the below activities:

1) Setup all the database parameters correctly as per note 830576. Run the attached script in the note and check accordingly.

2) Have you collected SYSTEM DB and DB Dictionary Statistics as described in note 838725?

3) Do you have the latest Optimizer patch as mentioned in note 981875?

Best regards,

Warren

[Former Member]

Hi Ahmed,

It means the system performance must be ok.The problem is due to your Database performance.As told by Sergo you need to perform check DB from Db13 and after it you can go for the update statistics.Apart from this you can go for sgen also to take a try.

Thanks,

Satyabrat

[Former Member]

Hi Ahmed,

Please let me know your size of the memory and the paging you have set for the system.

Thanks,

Satyabrat

[Former Member]

Dear Sergo Beradze,

First, thanks for reply,

I already check ST02 and I changed some parameters but nothing changes,

Regarding DB13 we are not yet implemented BR*Tools, for sm21 I canu2019t see any errors or warnings related for this issue,

Anyway while I run these procedures I can see from OS Level with windows Task Manager Processes tape page, Oracle.exe took 99% of CPU, otherwise this hanging only with this transaction code,

My windows operating system is 64 bit

Regards,

Ahmed Saber

[Former Member]

"Regarding DB13 we are not yet implemented BR*Tools"

try to implemete it. You need to do "update database statistics" (we do it every day). May be it helps, also

"check DB" gives you other information about this problem.

Are you check alert_sid.log ? Regards.

[Former Member]

Hello. try to check ST02 all are OK? Also in DB13 "check db" are OK? Your OS are 32 or 64? In windows "event logs" all are OK? The memory you use are? In SM21 and ST22 any messages or dumps? Any other slow transactions or only this? In Oracle alert_sid.log errors(before check "check db" in DB13? Regards.