I’ve searched and read wide about the good practices of configuring swap space for Oracle Database installation. I am aware that for 1-2GB RAM, swap has to be 1.5x. For between 2GB and 8GB, swap needs to be equal to SGA. Above 8GB, swap will be twice SGA size (I stand to be corrected).
However, just yesterday, someone introduced something that got me confused. He said, “For Oracle Database or Oracle RAC on systems, available swap space must be at least equal to the sum of the SGA sizes of all instances running on the servers.”
I am a bit confused because I am aware that even though it is a RAC environment, each server has its OS and maintains its internal memory separately hence, the swap for each serverdoesn’t have to be equal to the sum of SGAs as indicated by my colleague.
Can anyone please help me understand what the correct value should be?