Consumer Group Mapping

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#i1007556

BEGIN
dbms_resource_manager.clear_pending_area();
dbms_resource_manager.create_pending_area();
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.oracle_user,
    'YBBUSER',
    NULL
);
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.oracle_user,
    'YBBUSER',
    'OLTP'
);
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.client_os_user,
    'ybb01',
    'DEFAULT_CONSUMER_GROUP'
);
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.client_program,
    'sqlplus',
    'BATCH'
);
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.service_name,
    'PROD',
    'OLTP'
);
dbms_resource_manager.set_consumer_group_mapping(
    dbms_resource_manager.module_name,
    'sqlplus',
    'DEFAULT_CONSUMER_GROUP'
);
dbms_resource_manager.submit_pending_area();
END;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License