Prior to 11.2, the following set of init.ora parameters were recommended:

*.db_cache_size=64m  
*.large_pool_size=12M
*.shared_pool_size=128M
*.processes=300

Going forward with 11.2 and higher, oracle recommends setting memory_target to approximately 1.5 GB. Also, you will notice that we are leveraging memory_target versus sga_target which insinuates that we are not using huge pages for ASM memory structures:

alter system set memory_target=1536m scope=spfile;

The equation for the process parameters is:

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

Where n is the number of databases connecting to ASM.

Posted by Charles Kim, Oracle ACE Director

Posted in ASM
Share this post, let the world know

Comments are closed