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 Sebaraj ,

We have already restarted the servers.

Will u please tell what is the bug in oracle listner as you said and how u fixed?

Regards,

Rahul.

[sebastian_sebaraj]

It is a Oracle's bug (5576565). Memory leak affects the performance, We are running on AIX, we have a job to stop and start the Listener alone once a week. Oracle & SAP will be up and running while this job runs. This happens when lot of connection is requested. I do not know about your application request to listener.

Bug is fixed only in 10.2 or something , I am not sure exact release.

Edited by: Sebastian Sebaraj on Dec 5, 2008 12:05 PM