Shared Memory and the SGA
The larger the SGA, the better, as frequent I/O in RAM is significantly faster than the same from disk.
SGA size must be balanced with memory requirements of the OS and other running applications.
- Too much results in excessive paging.
- Too little results in high disk I/O.
Unix variants offer unique shared memory features to enhance the performance of Oracle.