Consumer group

▣ 경합 시 우선권 부여

   

▣ consumer group

   

▶ Show SQL

BEGIN

dbms_resource_manager.clear_pending_area();

dbms_resource_manager.create_pending_area();

dbms_resource_manager.create_consumer_group(consumer_group => 'OLTP', comment => '', cpu_mth => 'ROUND-ROBIN');

dbms_resource_manager.submit_pending_area();

BEGIN

dbms_resource_manager_privs.grant_switch_consumer_group('HR', 'OLTP', false);

END;END;