1)登录数据集市数据库
gccli -ugbase -ppwd
2)查看有哪些数据库
show databases;
3)选择数据库
use gbase;
4)查看现有的资源池名与分配的内存量(单位是b)
select resource_pool_name,max_memory from resource_pool;
5)查看数据库中现有的资源计划
select * from resource_plan;
6)关闭资源计划
set galobal active_resource_plan = ' ';
7)根据需求修改资源池的内存使用量
ALTER RESOURCE POOL res_chiz SET (max_memory=8192);
ALTER RESOURCE POOL res_fy SET (max_memory=12288);
ALTER RESOURCE POOL res_chiz SET (max_memory=15360);
ALTER RESOURCE POOL res_chiz SET (max_memory=8192);
8)激活资源计划
set global active_resource_plan = ‘plan_ca’;
9)修改完再次查看修改是否正确
select resource_pool_name,max_memory from resource_pool;
标签:SET,resource,max,ALTER,修改,内存,memory,RESOURCE,gbase From: https://www.cnblogs.com/xurui96/p/17085137.html