Thanks all ,this is a great list!
=== At 2003-06-26, 10:17:00 you wrote: ===
>Richard Ji,ÄúºÃ£¡
>Hi £¬ how do you know that ISM is used even if multiple shared memory
> segment are used in solaris 8?
>
>
>
>>Matt,
>>
>>Your SGA can still be larger than 4G
Chao,
There are couple of ways to confirm whether ISM is used or not.
The easiest way on Soalris 8 is run pmap on an Oracle process
and you will see "ism" in those shared memory segments. Below
I set my SHMMAX to 100m and my SGA to 300m+.
0400 10K read/write/exec/shared [ ism sh
Richard Ji,ÄúºÃ£¡
Hi £¬ how do you know that ISM is used even if multiple shared memory
segment are used in solaris 8?
=== 2003-06-26 09:24:00 ÄúÔÚÀ´ÐÅÖÐдµÀ£º===
>Matt,
>
>Your SGA can still be larger than 4G even if SHMMAX is not larger than
>4G. When
Matt,
Your SGA can still be larger than 4G even if SHMMAX is not larger than
4G. When SGA size > SHMMAX, mutilple shared memeory segements will
be allocated. There used to be a claim that if you can fit the SGA
into a single shared memory segment, ISM will be used. This might
be true for older
As long as you're running 64-bit solaris and 64-bit oracle, you can set
SHMMAX to be larger than 4G, which will allow your SGA to be larger than
4G. Keep an eye on your overall memory pressure, though, to make sure
you don't oversubscribe the system. If you're running Solaris 8/9
and/or using so