星期二, 5月 18, 2010

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

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...