BestPracticesandRecommendationsforRACdatabaseswithSGAsizeover100GB
Best Practices and Recommendations for RAC databases with SGA size over 100GB(文档 ID 1619155.1)
a. Set _lm_sync_timeout to 1200
Setting this will prevent some timeouts during reconfiguration and DRM. It's a static parameter and rolling restart is supported.
b. Set _ksmg_granule_size to 134217728
Setting this will cut down the time needed to locate the resource for a data block. It's a static parameter and rolling restart is supported.
网站题目:BestPracticesandRecommendationsforRACdatabaseswithSGAsizeover100GB
文章地址:http://scgulin.cn/article/geipdh.html
a. Set _lm_sync_timeout to 1200
Setting this will prevent some timeouts during reconfiguration and DRM. It's a static parameter and rolling restart is supported.
b. Set _ksmg_granule_size to 134217728
Setting this will cut down the time needed to locate the resource for a data block. It's a static parameter and rolling restart is supported.
网站题目:BestPracticesandRecommendationsforRACdatabaseswithSGAsizeover100GB
文章地址:http://scgulin.cn/article/geipdh.html