Skip to Main Content

Oracle Database Discussions

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!

How to minimize CPU usage of Background Process?

Beauty_and_dBestDec 10 2017 — edited Jan 3 2018

11gR2

OL6

Hi ALL,

We have a TEST database which is supposedly "idle" since no one is using it right now.

But when I monitor "top" command, I see processes with high CPU usage which constantly sitting at the top spot, all the time.

It seems that this program is "looping" infinitely?

How do I minimize its CPU consumption?

The processes belongs to ora_qmnc_UAT and all ora_q000_UAT sub-processes.

Capture.PNG

Please help....

Kind regards,

jc

This post has been answered by John Thorton on Dec 19 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2018
Added on Dec 10 2017
20 comments
971 views