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