Shulou(Shulou.com)06/01 Report--

Best Practices and Recommendations for RAC databases with SGA size over 100GB (document 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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.