Very slow system - Performance Problems

[Former Member]

Hi gurus,

I decide to create this message because I´m faccing with a very bad and persistence problem with my system! Help me please I don´t know what can I do more... I don't get how I solve this problem.

I installed this system an one week ago... and since there the users have notice some problems in it performance!

The system is an ECC 6.0 SR3 with Oracle DB 10.2.0.4 in windows 2008 server x64. After I installed the system I did some tasks that is mentioned in chapter 5 Post-Installation on Installation Guide of SAP ERP 6.0 SR3 ABAP. Those tasks were the checking the recommended Oracle Database Parameters (830576) update Oracle database statistics (note 838725) I also checked the note 974781 which recommend which Internal database maintenance jobs is important or not in Oracle 10.2. And some momments ago I read the note 146289 Parameter Recommendations for 64-Bit SAP Kernel and apply some recomentation mentioned in there, inside of this note sap talk about other nome that in my opinion is important... I don´t know if that is important that is the note 103747 which is for SAP profile parameters that are not covered in note 146289.

I don´t know what I should do to solve this problem... I already check the ST02 and ST06.... but I´m not an expert and I don´t understand what some values in there represent for the all system performance!

Like I said above what I did until now was create and run oracle statistics, fix some problems in Oracle parameters that sap recommend to change and I apply all recommendation in internal database maintenance jobs.

The system is very slow and before entry in each transaction the system show a message "Cannot start transaction SMEN" (Image 1) and after that it open the transaction in other sap window/new session!! Other sign it is when we are in a transaction and we do a back window (F3) the system display another message/window with "Start SAP Easy Acess" (Image 2).

*Image 1 --» http://img94.imageshack.us/img94/2483/17592155.png

*Image 2 --» http://img267.imageshack.us/img267/4112/85809003.png

Can you help to solve this problem.. what I have to do..?

Best regards,

João Dimas - Portugal

[Former Member]

Hi,

Can you paste an image of the following :

Trx: ST04OLD

ST06

Contents of you spfile.ora

Mark

[Former Member]

Hello Mark Norman,

This problem was already solved.

This was caused by me I believe when I put a logon image in fisrt screen SAP menu.

I was so stupid... this was caused by my inexperience... and so I apologize to all for this and the time dispend in this problem/post... Sorry!

The only thing that in fact was wrong and it resulted in that stupid behavior of system was in table SSM_CUST in NEW_WINDOW_MODE which was with value = YES and sinceraly I don´t know why and for what I changed this value!

I didn't want to believe that was in fact the problem... sorry guys, and I sincerely thank you to all of you that tried to help me is always a honor and an inspiration to me to learn with you about other things that was approach in this post! I´m always learn with you... believe me!

Sorry more one time!

Best regards to all

João Dimas - Portugal