My Oracle Support Banner

Using Resource Manager, Consumer Groups Mapping Incorrectly to Other_Groups (Doc ID 855252.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Using resource manager to control the cpu usage for applications using different service names.

Map a service name with a resource group.  However, when query v$session, instead of seeing the correct resource group assigned according to the mapping, we see OTHER_GROUPS.

Example:

SQL> select * from dba_rsrc_group_mappings;

ATTRIBUTE VALUE            CONSUMER_GROUP 
------------------------------ ------------------
SERVICE_NAME AIM_DEV_IDM AIM_IDM_GROUP
SERVICE_NAME AIM_DEV_PC AIM_PC_GROUP
SERVICE_NAME AIM_DEV_RM AIM_RM_GROUP

SQL> select * from dba_rsrc_mapping_priority;

ATTRIBUTE PRIORITY STATUS
------------------------------ ---------- ------------------------------
EXPLICIT 1
SERVICE_MODULE_ACTION 2
SERVICE_MODULE 3
MODULE_NAME_ACTION 4
MODULE_NAME 5
SERVICE_NAME 6
ORACLE_USER 7
CLIENT_PROGRAM 8
CLIENT_OS_USER 9
CLIENT_MACHINE 10

SQL> select username, resource_consumer_group, service_name from v$session where service_name like 'A%';

USERNAME RESOURCE_CONSUMER_GROUP SERVICE_NAME
------------------------------ -------------------------------- ----------------------------------------------------------------
SYSTEM OTHER_GROUPS AIM_DEV_PC
SYSTEM OTHER_GROUPS AIMDEV_DBA

Cause

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
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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