Database Administration (MOSC)

MOSC Banner

HELP - Can't use DBMS_RESOURCE_MANAGER.SET_MAPPING_PRIORITY

edited Jan 7, 2009 10:03PM in Database Administration (MOSC) 5 comments
 Hi,

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(

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center