Analytics Software

Yes. Each database will require its own SGA segment and additional databases will add too the total size required. POSIX or /dev/shm shared memory is similar to a RAM disk, which maps memory to virtual files to be shared among processes. By default, the maximum size of /dev/shm is 50 % of the physical or installed RAM. It does however not reserve or allocate RAM other than what is actually being used.

Keep in mind that Oracle database AMM and /dev/shm are not recommended for large memory configurations. As I recall, if your SGA is greater than 2 GB, you should use kernel hugepages instead. Kernel hugepages are more efficient due to larger memory pages, which requires far less resources for memory management and results in much better performance.

An Oracle database instance can use SYS V shared memory, which is either kernel hugepages or conventional 4k memory pages, but cannot use POSIX /dev/shm for SGA and SYS V at the same time. You can however use different shared memory concepts for different Oracle database instances on the same server. For example, running an +ASM instance using AMM and another Oracle database using kernel hugepages and ASMM.

Speaking of shared memory, the SHMMAX kernel parameter applies to SYS V shared memory only. It's a safeguard parameter to limit how much shared memory a process can possibly use and needs to be large enough to fit the largest SGA of any of your Oracle databases. SHMMAX for a server that runs Oracle database is typically set to 4 TB or whatever the platform being x86 or x64 theoretically supports. SHMMAX does not apply to POSIX /dev/shm and Oracle AMM.

For more info, see the following:

https://docs.oracle.com/cd/E11882_01/server.112/e10839/appi_vlm.htm#UNXAR385

Btw, if you have to use OS release 5, use 5.11 at least. There is no reason to run 5.6, which is obsolete.