ST02/ Buffer Errors

[Former Member]

Hi

This is a new implementation with the configuration mentioned below.

Windows 2003 Server (SP1)

Oracle 9.2

8GB Ram

ECC 5.0

HP Proliant DL380G5 / Tape Device: HP DLT VS160

750GB Raid

I see a lot of Red Highlights under ST02

These are for

Swaps with value 1199334 for field description

Swaps with value 2030958 for Initial Records

Swaps with value 8715.952 for Program

Swaps with value 1080.867 for CUA

Swaps with value 173.431 for Screen

Swaps with value 2334 for Generic Key

Swaps with value 1087 for Single Record

Swaps with value 7689980 for Export / Import

As a result of the above and more, the production system seems very slow. The resopnse time for transactions (SAP Default) is on a average of 10 seconds, sometimes going up to one minute.There are no background jobs running during the day and no backups as well. The tablespace's and file system also have sufficient free space. There are sufficient work processes and we also check the size of archieve log on a regular basis (making sure Archieve not being a cause) I have a feeling that the errors could be because of incorrectly configured profile parameters, however identifying what is right and what isnt is becoming a difficult task.

You could see a snapshot of the ST02 screen here

http://img138.imageshack.us/my.php?image=st02outputxe7.png

Further here are the screenshots of CCMS buffer stats

http://img99.imageshack.us/my.php?image=ccmsbufferstatskq7.jpg

There are also a lot of table locks that i see

http://img263.imageshack.us/my.php?image=tablelock1rh3.jpg

http://img254.imageshack.us/my.php?image=tablelock2br9.jpg

http://img99.imageshack.us/my.php?image=tablelock3ta6.jpg

We will be going in for a Early watch support from SAP however till then we are stuck with these issues.

Could you share your ideas on how I can fix these ?

best regards

Ravi

[Former Member · Accepted solution]

Hello Ravi,

Does any of your WP go in PRIV mode ?

In first time, it seems your parameter abap/buffersize is too small

Regards

Francois

[Former Member]

Hi Ravi,

You can use the following command to know what are all the parameters to be changed and what would be the prefferable values.

sappfpar check pf=
usr\sap\trans\tpparam

(or)

sappfpar check pf=
usr\sap\trans\tp_domain_<sid>

Regards,

N.Amarnath

[Former Member]

Hi Ravi,

Since, there are many locks hanging in SM12, I doubt whether it is due to enque resourse consumption. Check the note 97760 and try addressing the issue in this area.

Let me know the outcome.

regards,

VInodh.

[former_member192350]

Most of those swaps are caused by insufficiently sized buffers. Try to keep the % free (both size and entries) columns at 20% free or better. Is this a 64-bit or 32-bit Windows environment? In a 64-bit environment there shouldn't be an issue with increasing these significantly.

Rich

[Former Member]

Hi Rich

Its a 64 bit system. I did not notice work processes in PRIV mode.

regards

Ravi