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

Last updated on DECEMBER 06, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms