shmmax equal to RAM

[Ramones]

Hi
What could be the impact of increasing the kernel parameter shmmax to be the same size of system RAM?

Thanks,
R

[Court Campbell]

No impact at all.

[David Child_1]

There is no direct impact, but there could be side effects if your DBAs don't think things through and decide to use all that space.

David

[skt_skt]

Here is a SHMMAX rule of thumb.

The maximum usable setting for this paramter is 25 percent of memory. Memory in this case is defined as RAM plus swap.

[Sajjad Sahir]

Dear Ramones

the answer is no


thanks and regards

Sajjad

[Sajjad Sahir]

Dear Ramones
more clarification

how much RAM and swap in u system and what about free memory, which database is using what about the status
Dear my opinion is please don't set shared memory mmax higher than your RAM plus SWAP.
before changing any parameter, be sure that u know what is the effect on the system performance.

thanks and regards

sajjad