Re: SHMMAX parameter

Hello Limin,

I don't see why Oracle SGA should actually take more space than its actual size. SHMMAX is only a limit to a maximum bunch of shared memory, and indeed you won't be able to allocate single SGA of bigger size.

Hope this helps,
Igor

guo_at_andrews.edu wrote:
>
> I have a unix machine with SHMMAX=150MB. There are mutiple Oracle instances
> running on this machine.
>
> Question:
>
> If the SGA size is smaller than 150MB, for example, 50MB, How much
> physical memory does this instance SGA take? 150MB or 50MB?
>
> Thanks for any inputs?
>
> Limin.

--
Igor Sereda,
ITC, Russia Received on Tue May 05 1998 - 15:18:25 CDT