ITPub博客

首页 > 数据库 > Oracle > Best Practices and Recommendations for RAC databases with SGA size over 100GB

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

原创 Oracle 作者:kunlunzhiying 时间:2017-08-02 15:27:36 2 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/28211342/viewspace-2142976/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
IT搬砖

注册时间:2014-07-28

  • 博文量
    665
  • 访问量
    568694