on 08-30-2008 8:13 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi Ahmed,
Please let me know your size of the memory and the paging you have set for the system.
Thanks,
Satyabrat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.