This content has been marked as final. Show 3 replies
What is the shared memory allocated at os ?
kctune -v -q shmmax
Description Maximum size of a shared memory segment (bytes)
Current Value 4398046511104
Value at Next Boot 4398046511104
Value at Last Boot 4398046511104
Default Value 1073741824
Constraints shmmax >= 2048
shmmax <= 4398046511104
Can Change Immediately or at Next Boot
If you have calculated Total memory based on RES/SHR component of top then higher limit per process can be as high you have allocated share memory at OS level
If calculated based on Virtual then it has upper limit of your SGA.
Oracle server processes can eats up as much as memory available in system until they are restricted at OS level per osuser which leads to more paging