Asm Instance Parameter Best Practice
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
10g/11gR1
Processes = 25 + (10 + [max number of concurrent database file
creations, and file extend operations possible])*n
11g.2.0.3
In 11.2.0.3, the "PROCESSES" parameter will be default to "available CPU cores * 80 + 40" (in the ASM spfile). As the default value for "MEMORY_TARGET" is based on "PROCESSES", it can be insufficient if there is a large number of CPU cores or large number of diskgroups which could cause issues (i.e. Grid Infrastructure stack fails to stop with ORA-04031 etc) per Bug:13605735 & Bug:12885278, it is recommended to increase the value of MEMORY_MAX_TARGET & MEMORY_TARGET before upgrading/installing to 11.2.0.3 (does not apply to 10g ASM):
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
HammerDB Best Practice for PostgreSQL Performance and Scalability
https://www.hammerdb.com/blog/uncategorized/hammerdb-best-practice-for-postgresql-performance-and-scalability/HammerDB Best Practice for PostgreSQL Performance and ScalabilityThis post gives a ...
HammerDB PostgreSQL Performance postgresql sql -
Best practice of Internet service operation in Windows
戳右边 http://t.cn/zjtfZkC欢迎发邮件和我探讨,cenchao@live.cn
Windows service Internet operation practice -
taro best practice
taro best practice> 最佳实践
taro best practice Taro React js 最佳实践 -
JavaScript Best Practice
JavaScript Best PracticeClean, maintainable, execute codeJavaScript Best PracticeClean, maintainable, execute code
Clean maintainable execute code js -
Git Best Practice All In One
Git Best Practice All In Onegit workflow
git workflow git Best Practical 开发环境 开发人员