SHMMAX on Linux/ Oracle 8.0.5

From: Harinder <htakhar_at_yahoo.com>
Date: Tue, 21 Sep 1999 09:23:14 +0530
Message-ID: <7s848g$mp1$2@news.vsnl.net.in>

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 Received on Mon Sep 20 1999 - 22:53:14 CDT