Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/Solaris Kernel Tunables Question

Re: Oracle/Solaris Kernel Tunables Question

From: Kevin Counts <kcounts_at_helios.acomp.usf.edu>
Date: 24 Mar 2003 20:09:38 -0800
Message-ID: <f2ac0433.0303242009.4c16e6bd@posting.google.com>


Chuck <ccarson_at_echeeba.com> wrote in message news:<3E7F51E7.20509_at_echeeba.com>...
> We are moving from a 4GB Solaris 8 64-bit box to a 10GB box, does it
> make sense to increase the shmmax parameter?
>
> Currently we have:
> set shmsys:shminfo_shmmax=2097152000
>
> Does this line limit the SGA to 2 GB?
>

On a 64 Bit Solaris 8 machine shminfo_shmmax may be set to a maximum of MAXINT64 per http://docs.sun.com/db/doc/816-0607/6m735r5f7?a=view

/usr/include/sys/int_limits.h

#define INT64_MAX (9223372036854775807LL)

If you are running 64 bit Oracle then definitely increase the maximum size of a SysV shared memory segment to support a big SGA if you have the extra memory although I believe even if you are running 32 bit oracle you can still get ~ 3.75 GB of an SGA if you increase your max shared memory segment.

Regards,

Kevin Received on Mon Mar 24 2003 - 22:09:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US