Skip to Main Content
  • Questions
  • How to resolve resmgr:cpu quantum wait event.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ingimundur.

Asked: November 11, 2024 - 11:07 am UTC

Last updated: December 04, 2024 - 5:26 am UTC

Version: 19

Viewed 100+ times

You Asked

Hi Team,

I have tried to find good explanation for this wait event online, but not found anything that gives me a clear and concise answer.

Recently we have started getting "resmgr:cpu quantum" wait event on our production database. This is a database with 40 CPUs and is run on exadata.

I have tried all the scripts I could fin online to determine what is the problem, but I cannot see that we have too much happening on our machine at the time of the event. Are there maybe some other events I should try to find in conjunction to this one?

Hope you can help.

Ingimundur K. Gudmundsson

and Connor said...

"resmgr:cpu quantum' means we are deliberately throttling some sessions to avoid exceeding a CPU resource limit.

This might be overall server load being too much for the machine, or it might be artificially constrained by some setting, eg if you set cpu_count to 10, then after 10 cpu's "worth" of work, we will start to limit things. (Some material here https://www.oracle.com/technetwork/database/performance/instance-caging-wp-166854.pdf )

Start with your standard AWR reports. There is rule that says it is the sessions that are having this wait that are the issue - they might be just the victims of other sessions being too hard on the server.

Check your standard metrics - "DB Time", "Average Active Sessions" etc.

Also, check your alert log to ensure that you are not errantly in a resource manage plan that you did not intend to have active. (Note - there are some preconfigured ones even if you didnt create any). You could explore *temporarily* turning off resource manager (set the parameter to null) to see if it has an impact to help with root cause detection.


More to Explore

Performance

Get all the information about database performance in the Database Performance guide.