1）查看现有的资源池名与分配的并发数
select resource_pool_name,max_task_number from resource_pool;
2）查看数据库中现有的资源计划
select * from resource_plan;
3）关闭资源计划
set global active_resource_plan = '';
4）根据需求修改资源池的并发数
ALTER RESOURCE POOL res_develop_dynamic SET (max_activetask=20);
ALTER RESOURCE POOL res_product_dynamic SET (max_activetask=20);
5) 更改 UBAW 用户所属资源池
alter consumer group res_develop remove user UBAW;
alter consumer group res_product add user UBAW;
6）激活资源计划
set global active_resource_plan = 'plan_develop';
7）修改完再次查看修改是否正确
select resource_pool_name,max_task_number from resource_pool;
8）确认资源组变更成功
select a.consumer_group_id,a.user_name,b.consumer_group_name from(select*from gbase.consumer_group_user where user_name='UBAW') as a , gbase.consumer_group as b where a.consumer_group_id=b.consumer_group_id;
