SWAP'ящий оракл

swappiness в ядре покрути или отключи совсем своп, зачем он тебе?

Да, в /etc/sysctl.conf vm.swappiness=0, а отжать - swapoff /dev/swapdevice && swapon /dev/swapdevice

Under Eager swap, as a process consumes memory, it also marks the same amount of swap space as used, so, for example, if your oracle database has 6G RAM allocated in the SGA, it will allocate both 6G RAM and 6G swap. If there is insufficient swap space, it won?t kill other processes to make space. It will lock up the program attempting to allocate space, and eventually any other processes on the system that need swap space will also hang. In Solaris, I have seen such errors as ?unable to fork a process? or Solaris error 12, not enough space. In oracle, you will get messages like this: TNS-12500, TNS-12540, TNS-12560, TNS-00510. Usually your server will lock up shortly after the note enough space or unable to fork a process message.