My Oracle Support Banner

High "Resmgr:Cpu Quantum" Wait Events Even When Resource Manager Is Disabled (Doc ID 949033.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


Issuing a sqlplus / as sysdba might be hanging and/or high waits on event 'resmgr:cpu quantum' might be noticed even when resource manager is disabled.    

You already have confirmed parameter RESOURCE_MANAGER_PLAN is set to null but still noticing the above wait events.

Top 5 Timed Foreground Events:

Event                    Waits   Time(s)  Avg wait(ms) % DB time Wait Class

------------------------ ------- -------- ------------ -------------- ---------- -----------

resmgr:cpu quantum         1,596  346,281       216968          89.19 Scheduler

db file scattered read   171,071   14,778           86           3.81 User I/O

log file sync             28,575   10,810          378           2.78 Commit

db file sequential read  943,457   6,569             7           1.69 User I/O

DB CPU                     2,133   0.55




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.