Oracle and shmmax and shmall

A good article on Oracle and shmmax and shmall. In a nutshell:

  • shmall it is not the maximum amount of memory which can be allocated, it is the maximum size of any shared memory chunk – how big a bite you want per bite from free memory.
  • shmmax – its value determines the maximum amount of memory that ALL shared memory can take. the actual setting is derived… the maximum amount of memory = shmall * pagesize where pagesize = getconf PAGE_SIZE and shmall = cat /proc/sys/kernel/shmall
Tags:


Share This


 


One Response to Oracle and shmmax and shmall

  1. Handy if you mix up shmall and shmmax..

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>