Best Practices and Recommendations for RAC databases with SGA size over 100GB

千家信息网最后更新 2026年11月01日Best Practices and Recommendations for RAC databases with SGA size over 100GBBest 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.