Re: SHMMAX on Linux/ Oracle 8.0.5

Harinder wrote:
>
> Friends,
> I have installed Oracle 8.0.5 on a RedHat 6.0 system with 512 Mb RAM and a
> 2Gb swap space.
> It runs perfectly fine.
>
> SGA size as defined by me in init.ora is 6Mb. Which I think is more than
> enough for
> a database of 8 tables with not more than 500 rows in any of them.!
>
> What I would want to know is:
> Why does the documentation with Oracle and even Oracle support recommend a
> SHMMAX value of 4 gig???
>
> The default value in redhat 6.0 is 32 mb. And Oracle seems to be working
> fine on that. I wanted to know
> as to how does a value of SHMMAX = 4Gb work when the total memory on the
> system is 512 Mb + 2Gb (swap)
> ??
>
> Is this not funny that Oracle still wants me to recompile the kernel and set
> SHMMAX to 4 Gb.
>
> -Harinder

Hi
 the SHMMAX is the limit that most Unix's have. If you set it to the max you don't have to screw around ever again with this config. It's just setting the maximum that is allowed and doesn't really effect any internal performance by setting it this high, just means you can reconfigure Oracle and not worry about this again.

martin Received on Tue Sep 21 1999 - 04:13:25 CDT