Re: Max SGA size for 32-bit 9.2.0.6 on Solaris

From: <yong321_at_yahoo.com>
Date: 7 Jul 2005 10:35:04 -0700
Message-ID: <1120757704.049599.216860@g43g2000cwa.googlegroups.com>

Kalle,

If you want to create a > 2GB (actually about 1.75 GB) SGA with your software, you may be able to do so by setting shmmax to a small value. See
http://rootshell.be/~yong321/computer/sgabegbug.txt

This creates multiple shared memory segments, which may slow down new oracle process creation.

In any case, leave plenty of free memory for OS page cache. You can't predict when Oracle can't manage its memory the best way you want.

Yong Huang Received on Thu Jul 07 2005 - 12:35:04 CDT