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

kunlunzhiying發表於2017-08-02
Database
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.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/28211342/viewspace-2142976/，如需轉載，請註明出處，否則將追究法律責任。

相關文章