This discussion is archived
1 Reply Latest reply: Jan 19, 2013 6:38 AM by flavioc RSS

ora_d000_ process costs too much CPU in APEX.

Royal Newbie
Currently Being Moderated
Hello Experts,

Env of APEX:
--------------------------------------------------------------------
CPU: 1C,2processor
Memory: 3G
Database: 11.2.0.2.0, 64 bit
OS: Oracle Enterprise Linux 5.7
APEX: 4.1.1.00.23
--------------------------------------------------------------------

I have build up a APEX application, and there are only no more than 30 users who use this application, and no more than 20 users were online at same time, during most of the time, the workload is quite low.

But I noticed that after the application(the database) started in 2 days, one of the two processors is very busy, 100% usage, and found out the background process "ora_d000_" costed the CPU.

The doc say APEX uses the Shared_server Mode, and I have set Shared_server=5 in the spfile.

Do you have any suggestion on this issues?

Thanks in advanced.

Royal.
  • 1. Re: ora_d000_ process costs too much CPU in APEX.
    flavioc Pro
    Currently Being Moderated
    Well, even if the database version is different and the operating system is different, I cannot hide the fact that this issue looks so similar to an old issue on Oracle XE10g.

    Although I managed to mitigate the problem over time by adding multiple dispatchers, it never went completely away, hence, from time to time, I need to kill the linux process that goes nuts.

    My personal feeling is that there is some resource (either a buffer or a counter or whatever) that constantly builds up until it blows up, causing this odd CPU spike.
    Interestingly enough in the case of Oracle XE10g this doesn't mean that the database become slow or unresponsive, on the contrary, it works normally (provided you have more than one dispatcher process otherwise it stops responding), but the CPU meters report that the CPU is spinning at 100%.

    http://oraclequirks.blogspot.com/2010/01/dispatcher-process-taking-99-of-cpu-on.html

    If you manage to find out what is causing it, I'll be most glad to hear from you, may be there is something that can be done in order to prevent such occurrence.

    Flavio

    -----
    http://oraclequirks.blogspot.com
    http://www.yocoya.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points