ISM or DISM Misconfiguration can Slow Down Oracle Database Performance
Last updated on APRIL 01, 2018
Applies to:Solaris Operating System - Version 10 3/05 and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
Interprocess communication (IPC) is the sharing of data and synchronization of events among processes. Shared memory provides efficient data sharing among multiple processes since data are not required to be moved across multiple process address spaces. Shared memory allows sharing of physical memory pages by multiple processes. That means multiple processes can attach or have mappings to the same physical memory segment. Access to shared memory can be performed by simple pointer dereference in the code. Oracle uses shared memory to cache frequently used data blocks (buffer cache) and to facilitate communication (shared pool) among oracle processes (pmon, smon, dbwr, lgwr, and oracle shadow proceses). Semaphores are used to control concurrency between processes when data in shared memory needs to be modified. See detail.
Oracle Database uses shared memory extensively, Misconfiguration of shared memory during Oracle Database setup can result in lower than expected performance. The goal of this document is to identify those symptoms that lead to slower Oracle Database performance and present solutions to overcome these issues.
Be aware that there might be systems that have different requirements or supported states when it comes to using ISM/ DISM, see for example:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms