Oracle 10g ASM tuning

參見附檔 Oracle Database 10g Release 2 Automatic Storage Management Overview and Technical Best Practices (p.7) :

ASM SGA and parameter sizing

將以下參數加到 /opt/oracle/db10g/dbs/init+ASM1.ora

Processes = 25 + (10 + [max number of concurrent database file creations, and file extend operations possible] )*n

            The number n is the number of databases connecting to ASM

For example          = 25 + (10 + 10 ) * 2 =65

i.e :

processes=65

shared_pool_size=128M

large_pool_size=12M

db_cache_size=64M