Asm Instance Parameter Best Practice

简介:

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): 



本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1278218

相关文章
|
SQL Oracle 关系型数据库
能够管理ASM instance的三种角色
能够管理ASM instance的角色有三种,他们的分工如下:组描述     OS指定的组      具有的权限    能做的事情OSASM      asmadmin        SYSASM           ASM所有管理工作OSDBA      asmdb...
1138 0
|
Oracle 关系型数据库 数据库
rac11g错误:ORA-15097: cannot SHUTDOWN ASM instance with connected client
背景: 想停rac环境,之前10g都是用crs_stop -all 来停止,所以,这次也这样做的,没想到报了如下错误: [grid@rac2 ~]$ crs_stop -allCRS-2500: Cannot stop resource 'ora.
1100 0
|
SQL 关系型数据库 数据库
ORA-15149: another ASM instance found running on the host
【问题现象】 [grid@localhost ~]$ echo $ORACLE_SID +asm [grid@localhost ~]$ echo $ORACLE_HOME /u01/app/11.
1098 0
|
Oracle 关系型数据库 Windows
ASM INSTANCE CRASHES FREQUENTLY WITH ORA-15082 in 11g [ID 1056695.1]
ASM INSTANCE CRASHES FREQUENTLY WITH ORA-15082 in 11g [ID 1056695.1]   修改时间 15-DEC-2011     类型 PROBLEM     状...
1210 0
|
前端开发 Oracle Java
ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.1]
ASMCA fails to create 11.2 ASM instance when upgrading from 10.2 [ID 1125053.
1284 0