Troubleshooting Guide: Oracle Resource Manager
(Doc ID 975455.1)
Last updated on MARCH 15, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***
This Troubleshooting Guide is provided to assist you in solving Oracle Resource Manager related issues in a structured manner. It guides you through a step-by-step method. Diagnostic comments are included in the document to assist in the different troubleshooting steps.
This article addresses the most common problems defined at the moment of writing this article. This article will be extended with new Resource Manager reoccuring issues.
1. I'm able to create a plan, but I cannot enable it.
SQL> alter system set resource_manager_plan='MYPLAN';
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager
2. The session is not running in the correct consumer group.
3. Resources not distributed as defined in the Resource Manager plan.
4. dbms_scheduler jobs do not run under the desired consumer group
5. Wait event 'resmgr: cpu quantum' is appearing in the top 5 wait events.
If you were unable to find and/or resolve your problem with Resource Manager then please let us know by making a remark explaining the situation. In this way we can make sure all the problems will be covered over time in this article._$#$_
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
|Problem 1: I'm able to create a plan, but I cannot enable it|
|Problem 2: The session is not running in the correct consumer group.|
|Problem 3: Resources not distributed as defined in the Resource Manager plan.|
|Problem 4. dbms_scheduler jobs do not run under the desired consumer group|
|Problem 5. Wait event 'resmgr: cpu quantum' is appearing in the top 5 wait events.|
|Problem 6: After Upgrade to 11gR2, Resource Manager SWITCH_TIME to CANCEL_SQL does not work as expected|