Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

High CPU Usage

437968Aug 4 2006 — edited Jan 18 2007

Hi,

Just to give you a background so you're not too frustraded with this post, I'm a developer and not a DBA. I am incharge of a Oracle XE database and need some help on the DBA side of things.

Every so oftern, when I view the CPU processes (top in Linux) Oracle (PID = 1654, user = oracle) uses all free CPU. This means it runs around 99.9% utlization. The only time it goes down is if I run a query or start browseing a page in APEX, the back up again. Basically it's taking all system idle time.

Usually after a day or so this process will start hogging the CPU and never goes down. I have checked all the sessions and none is asigned to that PID so I don't think this is a client problem, more server.

That's as far as I can get on my own. I'm wondering if someone can please let me know how to find out what is causing this problem, and how to fix it.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2007

Added on Aug 4 2006

12 comments

1,641 views