asm与数据库实例内存参数建议

当数据库没有使用自动内存管理，需求修改SGA内存参数，适当支持ASM。

当使用了自动内存管理则不需要设置。

• PROCESSES initialization parameter—Add 16 to the current value

• LARGE_POOL_SIZE initialization parameter—Add an additional 600K to the current value

• SHARED_POOL_SIZE 根据数据库大小调

  For disk groups using external redundancy, every 100 GB of space needs 1 MB of extra shared pool plus 2 MB
  
  For disk groups using normal redundancy, every 50 GB of space needs 1 MB of extra shared pool plus 4 MB
  
  For disk groups using high redundancy, every 33 GB of space needs 1 MB of extra shared pool plus 6 MB

• 数据库大小计算公式

SELECT SUM(bytes)/(1024*1024*1024) FROM V$DATAFILE;
SELECT SUM(bytes)/(1024*1024*1024) FROM V$LOGFILE a, V$LOG b
       WHERE a.group#=b.group#;
SELECT SUM(bytes)/(1024*1024*1024) FROM V$TEMPFILE 
       WHERE status='ONLINE';