Originally posted by reydp
Your SGA size should be about 1/3 of physical memory.
In Oracle 7 that used to be the best possible ratio.
In Oracle 8 and 9 SGA can be half of the OS memory.

The goal for the future is to get the complete DB in memory!

P.S. I keep 2 big tables in memory of all instances on an Oracle Parallel Server. It improved performance a lot. Especially with some reports we run from Node 2. I did increase DB_BLOCK_BUFFER to 50.000.