Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/Solaris Kernel Tunables Question
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