HELP - Can't use DBMS_RESOURCE_MANAGER.SET_MAPPING_PRIORITY
I have created a simple resource plan on a Oracle 10.2.0.3 database.
Everything works fine and I can enable the resource plan but I found the users are not assigned to the right
consumer groups.
From what I read, I can use the DBMS_RESOURCE_MANAGER.SET_MAPPING_PRIORITY to enforce how the
mapping between sessions and consumer groups.
However, I encounter the following error :
SQL> begin
2 dbms_resource_manager.set_mapping_priority(
3 EXPLICIT => 1,
4 CLIENT_OS_USER => 2,
5 CLIENT_MACHINE => 3,
6 CLIENT_PROGRAM => 4,
7 ORACLE_USER => 5,
8 MODULE_NAME => 6,
9 MODULE_NAME_ACTION => 7,
10 SERVICE_NAME => 8,
11 SERVICE_MODULE => 9,
12 SERVICE_MODULE_ACTION => 10);
13 end;
14 /
dbms_resource_manager.set_mapping_priority(