sga_target设置大于100G遇到的一个bug ORA-00064: object is too large
来源:互联网 发布:c语言中的链表 编辑:程序博客网 时间:2024/06/15 17:49
主机内存256G,sga_target准备设置为160G,DBCA创建数据库时一直报错ORA-00064: object is too large to allocate on this O/S (1,15429280)
直接使用DBCA默认参数把库建好后,再次使用命令来修改,报错依旧。经查,参考文档Database startup can fail with ORA-00064 Errors with huge sga_target of over 40Gig (文档 ID 886312.1),也就是与SGA Granule Size相关,设置_ksmg_granule_size=33554432解决此问题。
文档部分内容:
CAUSE
The cause of this problem has been identified in Bug:5051962, which has been closed as not-a-bug. It is caused by the granule size needed for the new SGA size to be different than the one currently in use by the instance at the time the ALTER SYSTEM SET SGA_TARGET command is run.SOLUTION
This is expected behaviour: the granule size is set based on the size of the SGA. If you set a SGA parameter (such as SGA_TARGET) to a value which exceeds the value of the granule size that was calulcated at instance startup, then you must set the _ksmg_granule_size instance parameter as well to choose a larger granule size. As this parameter is not dynamically changeable, an instance restart is required.The following table, shows granule sizes for specific SGA sizes and releases of Oracle:
with fix 8813366 installed
See also document:947152.1 for details on the granule size and its impact.
The following SQL statement can be used to check the actual granule size in use by the instance:
SQL> select bytes from v$sgainfo where name like 'Granule Size';
So in order to implement the solution for the issue at hand, either:
- set SGA_TARGET to a value less than or equal to the previous one, or:
- set _ksmg_granule_size to a higher value (in this case the value was set to 32MB). When using a text parameter file, add the following parameter:
_ksmg_granule_size=33554432
When using a server parameter file, issue:alter system set "_ksmg_granule_size"=33554432 scope=spfile;
In either case, restart the instance for the changes to take effect.
0 0
- sga_target设置大于100G遇到的一个bug ORA-00064: object is too large
- ORA-01034: ORACLE not available 、ora-00064:object is too large to allocate on this O/S
- 【很经典的文章】Oracle 11g sga_target 设置
- Request header is too large
- sga_target大于指定值的sga_max_size
- mysql中Packet for query is too large的解决方案
- Glassfish Request URI is too large 问题的解决
- java.lang.IllegalArgumentException: Request header is too large的解决方法
- java.lang.IllegalArgumentException: Request header is too large的解决
- ORA-12899: value too large for column
- ORA-12899: value too large for column
- ORA-12899: value too large for...
- 遇到的一个bug
- MYSQL Packet for query is too large
- Packet for query is too large
- MYSQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- 什么是Maven?
- 外媒评选的最佳iPhone型号
- 设计模式(三) 生成器(Builder)
- 2003的负载均衡
- 为日期类型的控件添加focusLost事件
- sga_target设置大于100G遇到的一个bug ORA-00064: object is too large
- 顶你学堂MOOC证书代表了什么?
- 如何使用Git实现跨SVN管理
- 电感量的计算
- iOS armv7,armv7s, arm64
- libevent evconnlistener_new() 创建监听器函数
- JVM的分代
- 【展讯】关于卡的数据网络连接
- 针对全字母或全数字不换行的处理