My Oracle Support Banner

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***

Purpose

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.

Please refer Note 1484302.1 for Overview of Oracle Database Resource Manager and Note 1119407.1 for the Video Tutorial on Resource Manager

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. 

Problem Definitions:

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._$#$_

Troubleshooting Steps

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
Purpose
Troubleshooting Steps
 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
References

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