主机内存512G,sga_target准备设置为320G,
restore一个数据库过来测试,rman target /
startup mount 的时候,一直报错ORA-27102: out of memory
直接使用DBCA默认参数把库建好后,再次使用命令来修改,报错依旧。就是与SGA Granule Size相关,设置_ksmg_granule_size=33554432(之前是4M)解决此问题。
文档部分内容:
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.来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29551564/viewspace-2135864/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29551564/viewspace-2135864/