Kellyn Gorman continues a series on performance tuning in Oracle:
Let’s break it down:
- RESMGR = Oracle Resource Manager
- CPU Quantum = The time slice a session is allowed to consume CPU
This wait event indicates that a session is throttled by Oracle Resource Manager because it’s trying to use more CPU than its current consumer group allows. This is intentional: Resource Manager is designed to prevent a single user or group from monopolizing system resources.
Read on to learn more about this wait type and what you can do if you experience it.