disp+work processes makes CPU utilization 100%

[Former Member]

Hi,

Since last few days, few disp+work processes consumes 100% of cpu of an

application sever (of BW Production server).

The application server is used for reporting of analytics

from our SRM portal. But it is observed from last 2 days that few

disp+work processes occupy 100% of cpu.

So no supplier is able to see the analytics from SRM portal.

Please note that we updated the patch set of oracle from 9.2.0.6.0 to

9.2.0.8.0 and after that only the problem appeared.

Request you to guide accordingly so that smooth operations can be

restored.

Regards,

Rahul.

[Former Member]

HI Joe,

Thanks.

At the time of analytics reading time the following programs are read :

SAPLRSDRS

CL_SQL_STATEMENT==============CP

CL_RSR_REQUEST================CP

SAPLRRK0.

But in st04 it is not showing any cost on DB.

The OS of that app server is windows 2000. We have updated the also /3gb parameter in boot.ini.

It is still high CPU Utilizaion.

Kindly suggest.

Regards,

Rahul.

[Former Member]

Do check whether this Oracle upgrade is supporting your current kernel level. If not you need to upgrade your kernel too.

Also, do check it out R3trans & TP command, as this R3trans helps you in havving connection with Database.

Before doing any upgrades, it is always recommended to check PAM (Product Availability Matrix).

WWW.Service.sap.com/PAM