Skip to Content
avatar image
Former Member

Error with action u201CSequential Readu201D with Tableu201D USER_ADDR

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Aug 31, 2008 at 06:13 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2008 at 07:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • "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.

  • avatar image
    Former Member
    Aug 31, 2008 at 08:00 AM

    Hi Ahmed,

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

    Thanks,

    Satyabrat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2008 at 12:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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