2021-08-12
如何处理shared_pool参数值不一致
1、查询shared_pool参数值在RAC环境下不同
select inst_id,COMPONENT, CURRENT_SIZE
from gV$SGA_DYNAMIC_COMPONENTS
where COMPONENT like ‘shared pool’;
INST_ID | COMPONENT | CURRENT_SIZE |
---|---|---|
2 | shared pool | 16106127360 |
1 | shared pool | 19327352832 |
select inst_id,pool,sum(bytes) BYTES
from gv$sgastat
where pool is not null
group by inst_id,pool;
INST_ID | POOL | BYTES |
---|---|---|
2 | large pool | 268435456 |
1 | shared pool | 19411135672 |
2 | shared pool | 16178745216 |
1 | large pool | 268435456 |
1 | streams pool | 536870912 |
2 | java pool | 1879048192 |
1 | java pool | 1879048192 |
2 | streams pool | 536870912 |
2、由于shared_pool值不同导致了
shared_pool_reserved_size的值在不同实例不同
shared_pool值如何确定,在11G中人为修改成固定值是否合适?
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
