[ILUG] SHM problem with Oracle

[Niall O Broin]

On Tue, Jan 29, 2002 at 10:06:00AM -0400, Shirley Louise Coffie wrote:

> What I'm having problems with is setting the memory.  I don't seem to get 
> complaints from the system for icps.  I guess where I'm getting hung up is 
> setting the SHMMAX, SHMMIN, SHMMNI, SHMSEG, SEMMNI, SEMMSL, SEMMNS, SEMOPM, 
> and SEMVMX
> 
> >From what I can see the total allowable shared memory is determined by the 
> formula:
> 
> SHMMAX * SHMSEG
> 
> But this doesn't seem to make any sense.

In what way does this not make sense ?

Amount of beer = bottle capacity  X  number of bottles


SHMSEG = size of a shared memory segment (bottle capacity) 
SMHMAX = maximum number of shared memory segments (number of bottles)

Google is your friend, and will definitely give you less abuse than we will :-)

Searcing Google for "oracle linux shared memory" got 27600 pages and the
first of these was quite informative, even telling you about how to rebuild
a bit of Oracle for maximum performance. Oracle's like a Formula 1 racing car
- very expensive, very good at what it does, best not serviced by a back
street garage, and quite likely to crash and burn if not driven correctly.



Niall