Re: SHMMAX setting with multiple instances? Solaris 2.8, Oracle 8.1.7.4

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Fri, 13 Feb 2004 08:31:05 -0500
Message-ID: <20040213133105.GA6100@medo.adelphia.net>

On 02/13/2004 08:17:14 AM, Carmen Rusu wrote:
> Oracle install guide recommends the minimum value
>
> set shmsys:shminfo_shmmax=4294967295
>
> How does this number depend on the the available physical RAM on the
> box?
>
> Does this number depend on the number of instances on the box ?
>
> Did you experiment with this setting? Horror stories?
>
> Thanks,
>
> Carmen Rusu
>

Carmen, the number in question is 400MB and it is the maximum size of a shared memory segment on Slowaris. It also represents the largest SGA that oracle can construct in a single piece. It doesn't have any direct impact on your RAM unless you really allocate the SGA.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Feb 13 2004 - 07:31:05 CST